Chapter 22
AutoFilter
Filtering is an easy and very fast way to find—and work—with subsets of data in a table and/or database. A filtered table displays only the rows that meet the conditions you itemize or specify for a column or a number of columns. There are several improvements to the Excel 2010 and 2007 AutoFilter, including new options that allow you to filter by color or cell formatting.
To activate the AutoFilter, first select a single cell or a region in the table/database, as shown in Figure 22.1 for the sheet named Database in the Chapter 22 workbook file. There are three ways to activate the AutoFilter:
Filtered data will display only the rows that meet criteria or conditions you specify in your query/filter. It will hide rows that you do not want displayed.
Using the AutoFilter feature, you can create different types of filters: value, format/color, text, dates, and so on.
A drop-down arrow ↓ means that filtering is enabled but not applied. A Filter button ↓ means that a filter was applied.
Try not to mix formats like text and numbers or numbers and dates in the same ...
Get Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition 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.