Using AutoFilter

In Excel AutoFilter works by letting you filter the data you want to see. Learn all about using the AutoFilter function in Excel 2003 here.

Using AutoFilter

The AutoFilter feature makes filtering, or temporarily hiding, data in a spreadsheet easy. This allows you to focus on specific spreadsheet entries.

To use AutoFilter:

For example, if you would like to only view data from the West Sales Region, click the drop-down arrow next to Sales Region.


In this example, you would choose West. All other data will be filtered, or hidden, and only the West Sales Region data is visible.

Tip Click the drop-down arrow again, and select All to display all of your original data.