AutoFilter


show more AutoFilter provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

AutoFilter

The ability to filter the data in your spreadsheet is really one of the most powerful options that you have when you're working in Excel and I'm going to demonstrate for you a very quick way that you can add an auto filtering option to your tables. For those of you that would like to follow along, please go to your exercise files and open up EatCake Sales Forecast3. Once you've opened it up, select the area that you would like to filter and in this case, it is columns A through E in a row 3.

So I clicked, dragged and highlighted those areas using my mouse. You'll notice that they're shaded somewhat to identify that's the area that I'm working with. I now want to apply an automatic filter to those so I go up to my Editing group on my home tab in the ribbon. Click on Sort and Filter and scroll all the way down to the Filter command. Doing that adds drop-down lists in all of the different cells in that particular row. Now I'd like to filter by year, I simply need ...

AutoFilter
Video duration: 2m 21s 5h 13m Beginner

Viewers:

AutoFilter provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...