Filtering the Data
Filtering, or querying, is a quick and easy way to find and work with a subset of data so that you can display only the rows in your worksheet that meet the criteria you specify—for example, rows that contain specific text, or numbers that are greater than or less than a specific number. Filtering temporarily hides the rows that don’t meet your criteria so that you see only the data you’re interested in. Excel simplifies the power of filtering your data without your having to use a separate database. All you do is set up the filtering and select the items you want to display.
Filter the Data
Select the data you want to filter. ...
Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
