Page 132 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

Filtering Data

To filter data:

In our example, we'll apply a filter to an equipment log worksheet to display only the laptops and
projectors that are available for checkout.

1. In order for filtering to work correctly, your worksheet should include a header row,
which is used to identify the name of each column. In our example, our worksheet is
organized into different columns identified by the header cells in row
1: ID#, Type, Equipment Detail, and so on.

2. Select the Data tab, then click the Filter command.

3. A drop-down arrow will appear in the header cell for each column.
4. Click the drop-down arrow for the column you want to filter. In our example, we will
filter column B to view only certain types of equipment.

5. The Filter menu will appear.

123 | P a g e