GCFLearnFree.org

This class helped me get a promotion at work. I would recommend it to anyone!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Using AutoFilter

Excel 2003

Single page view print copy

Using AutoFilter

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:

  • Select Data from the main menu.
  • Select Filteraction AutoFilter.
  • Click the drop-down arrow next to the heading you would like to filter.

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

  • Choose the data you would like to display.

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.

previous next
previous 1 2 3 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.