Filtering Data in Excel Using Autofilter

We all know Excel is great for doing calculations but it is also handy for managing lists of data which means being able to filter information to find what you are looking for. When Excel 2007 came out there were significant changes to how the Autofilter works.

Here are two tutorials on filtering using the Autofilter feature one on Excel 2003 (which works for Excel 2004 and 2008 for Mac) and the other for Excel 2010, which works the same way for Excel 2007.

Autofilter for Excel 2003

Filter for Excel 2010

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel and tagged , , , . Bookmark the permalink.

One Response to Filtering Data in Excel Using Autofilter

  1. Helen says:

    I always wanted to know, how to clear multiple filters in one step and also how to disable the AutoFilter. Excel Aid gives me the solution on http://www.excel-aid.com/excel-clear-filters-clearing-all-filters-in-a-single-step-disabling-the-autofilter.html But your tutorial is also very clear and understandable. It:s a pity that I didn’t find your site earlier.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s