• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Working with Lists > Filtering a List

Filtering a List

As your list grows, you may occasionally want to view only rows that meet certain criteria. You can filter a list in this manner to generate a data subset for printing, charting, or record deletion, for example.

To apply an AutoFilter to a list

1.
Set the list for AutoFilter by choosing Data > Filter > AutoFilter or by clicking the Autofilters icon on the List toolbar.

When enabled, every column title is followed by a pair of arrows and the Autofilters toolbar icon is darkened.

2.
Click the AutoFilter arrows beside the column on which you want to filter and choose a filtering option from the drop-down menu (Figure 12.12).

Figure 12.12. To apply or remove a filter, click a column's AutoFilter arrows and choose an option from the drop-down menu that appears.


Only records that match the criterion are shown; the others are temporarily hidden.

3.
Optional: To further filter the list, you can set additional criteria for other columns.

4.
To restore all or some of the currently hidden records, do one of the following:

  • To show all list records, choose Data > Filter > Show All, or click the List toolbar icon and choose Filter > Show All.

  • If you've applied multiple filters, click the AutoFilter arrows for the filter you wish to remove and choose Show All.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint