Excel > Excel 2003 Intermediate > Sorting and Filtering

Autofilter

You can filter data to only display the rows that you want to see. All other data is hidden. You can also filter by multiple columns reducing your data each time to what you want.

Apply a filter

1. Select a cell in the range that you wish to filter
2. Click Data & Filter and then AutoFilter from the submenu that appears

Filter buttons appear in the first cell of each column (these should be your headers)

3. Click the filter button for the column you want to filter



4. Select a value from the list that appears

The list is filtered showing only the records requested

5. Repeat for each column you wish to filter from

Clear a filter

To restore the records as they were prior to filtering, you will need to clear the applied filters.

To clear a filter from one column:

1. Click the filter button for the column whose filter you wish to clear
2. Select All from the list

To clear the filters from all columns:

1. Click Data > Filter
2. Select Show All from the submenu

Removing the filter

Not that they are doing any harm, but you may wish to remove the filter buttons when you have finished with your filtering tasks.

1. Click Data > Filter
2. Select AutoFilter from the submenu

The filter buttons disappear and any filters you may still have applied are removed

Sorting a data list Custom Autofilter

Guides