Page 139 - Ms Excel Note and Workbook
P. 139
MICROSOFT EXCEL NOTE AND WORKBOOK
To use advanced number filters:
Advanced number filters allow you to manipulate numbered data in different ways. In this example,
we'll display only certain types of equipment based on the range of ID numbers.
1. Select the Data tab on the Ribbon, then click the Filter command. A drop-down
arrow will appear in the header cell for each column.
2. Click the drop-down arrow for the column you want to filter. In our example, we'll filter
column A to view only a certain range of ID numbers.
3. The Filter menu will appear. Hover the mouse over Number Filters, then select the
desired number filter from the drop-down menu. In our example, we'll
choose Between to view ID numbers between a specific number range.
130 | P a g e
