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.

Introduction

By the end of this module, you should be able to:

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.

AutoFilter

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.

Challenge!

Download and save the Employee Sales spreadsheet to complete this challenge.