Microsoft Excel - Filtering Autofilter

Filtering – AutoFilter.

In our ‘customers’ Table we are storing clients details (address, phone etc).

There may be thousands of records so we may want to filer out all the customers and only show the customers in the ‘UK & City of London’.

This is an easy process, all the Table headings have a small drop down arrow, the arrows were automatically displayed when the table was created.

The Process:

1.     Open the file that contains the Table.

2.     Click on the Heading drop-down arrows to display the filter options.

Select / deselect required information.

In this example the Table has already been filtered by country to only display the ‘UK’.

In the ‘UK’ there are two different cities, ‘London & Cowes’.

To only display ‘London’ remove the tick from the tick-box next to ‘Cowes’

Tip: If all the boxes are ticked and you wish to deselect without taking the ticks out one-by-one, click on the Select All, option. This option either toggles between deselect or selects all.

3.Click Ok.