When you filter a list, you display only the sets of data that meet your search
criteria. When you use the filter command, dropdown arrows are displayed to the
right of each column label in your data list. Clicking on a dropdown arrow displays
a list of all the unique entries in that column.
- Open the spreadsheet that contains the data you wish to filter.
- Click once within the data list.
- Click on the word Data in the Menu bar.
- Select the option Filter.
- Select the option AutoFilter from the submenu that appears.
- Dropdown arrows will now be displayed to the right of each column label.
- Click on a dropdown arrow to filter your data.
- You can filter by as many columns as you like.
Note: There will be a checkmark to the left of the AutoFilter
option when it is enabled. To remove your data filters, click on the word Data
in the Menu bar, select the option Filter, and click on the
option AutoFilter to remove the checkmark. All data filters
and their accompanying dropdown arrows will disappear.
Click HERE to return to the Table of Contents.