Applying Filters

Use the Filter tab in Buy Module to isolate and analyze specific data that may be hidden in a complex worksheet. The filter settings will also alter the data shown in the Filtered totals section on the Worksheet tab as well as on printed reports. The settings made on the Filters tab are temporary and will be disabled when you clear the filter or close the open worksheet.

To apply filter settings:

  1. Select the Filter tab.

Filter Tab

  1. To narrow the display of worksheet rows by selected criteria, choose any combination of filtering criteria using the check boxes and/or by selecting items from one of more of the list boxes.

  2. To change the sort on the worksheet, select a sort option from the Worksheet Table Sort drop down list. (The Worksheet Table Sort drop down list contains that same sort options found on the Preferences tab, except that any sort option that you select here is only in effect until you clear the filter or close the worksheet.)

  1. You can use the controls in the Advanced Filters/Formats box to create your own custom filters.

  2. Click <Apply> to return to the Worksheet which will reflect the active filters and/or sorts..

 

Related Topics:

Buy Module

Selecting and Deselecting Items

Advanced Filters and Formats

Modifying Filters

Clearing Filters