Microsoft Office Tutorials and References
In Depth Information
Exploring Special Filters
You’ve learned how to perform a
simple filter on your data, but Excel provides
even more ways to filter your data. Use the
AutoFilter feature to find missing data in your
worksheet, to display a list of the 10 best sales
districts, and even to see which invoices are due
to be paid next month.
4. Scroll to the bottom of the entry list and
click the (Blanks) option and click OK. As
shown in Figure 8-13, the (Blanks) option
will always appear at the end of the entry
list. If there are no blanks in the column,
there will be no (Blanks) option to click.
Searching for Blank Cells
Suppose you are the school administrator in this
example and you are responsible for accurately
maintaining this database of grades. The three
teachers submitted their data to you on Friday,
but some of the data was missing. You decide to
enter the data you have and leave blanks where
the data was missing and plan to fill in the
missing data on Monday.
You can scroll through the database searching
for the blank cells manually, but using Excel’s
AutoFilter would be so much easier. Excel can
easily find the missing data in your worksheet,
regardless of how big your spreadsheet becomes.
1. Choose Data > Sort & Filter > Filter to turn
on the AutoFilter feature.
The (Blanks) option appears at the
bottom of the entry list.
2. Click the filter arrow in the column header
where you want to find blank cells.
3. Click the Select All option to remove the
check marks from all of your data points.
Excel will display only those records with
blank cells in the column you selected
(see Figure 8-14).