AutoFilter

By filtering data, we can only view the data that meets certain requirements.
To filter data, choose the “Data” tab in the “Ribbon”.
First place the cursor in the range (this is often forgotten, even by me).
And click the “Filter” button.
This places a downward pointing arrow next to each field.

We click on this arrow when we wish to filter data from this particular column.

This opens a drop-down menu with various options.
These options depend on the data in the field.
Options for a field with text                                         Options for a field with numbers

If you apply a filter, the arrow changes to an icon of a filter.
When we place the mouse pointer over this icon, a small box appears with the text explaining the filter tat is applied.

To filter for a particular city, click the check box next to the text “(Select All)” and check the box or boxes, checking the cities that you wish to display.

Another example, if you wish to filter the representatives whose names begin with a letter d, then move your mouse over “Text Filters” and click the “Begins with …” in the drop-down menu.
In the “Custom Filter”dialog box, type in the letter ‘d’ in the box at the top right.
And click OK.

Again we can apply filters on different columns.
For example, in the image below, to filter the City column (Limburg), and the Representative column (Starts with d).

Remove Filter (s)

To remove the filters from your table, click the “Clear” button in “Data” tab of the”Ribbon’.

This removes all the filters applied in your table.
If you wish to remove only a particular filter, click the downward pointing arrow next to the box you wish to remove the filter, and choose “Clear Filter from ….”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats