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

Filtering a List

Lists grow quickly, and soon locating a particular record in the list may take more time than you like. When you just want to view a particular record or records, filtering the list enables you to display only the selected information you want to see. The list itself is unchanged; you use the filter to specify exactly which data you want to see at that particular moment, and hide the remaining records. You can change the filter at any time to display a different set of records. The filtered records can be formatted, edited, and even charted. The active filter is saved with the workbook. (Note, however, that Excel allows only one list at a time to be filtered on a worksheet.)

Excel offers two types of filtering. An AutoFilter applies an automatic (simple) selection filter to the list, which you then can customize. An advanced filter enables you to specify more elaborate criteria for filtering.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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