One More Filter Discussion: For Excel 2007
As you can see, I’m not quite done with the AutoFilter discussion for MS Excel 2007! For those of you who have been working with it, you have probably noticed that your filter down arrow gave you several more choices than the older versions ever showed.
So, as a result, I thought you might be up for a quick exploration of those extra items.
Let’s take a look at the options you get when using the AutoFilter feature in Excel 2007.
The top section allows you to sort the data on the current column values. That can be done either before or after a filter is applied.
In the sorting area, you have the standard quick ascending and descending sorts. The “Sort by Color” will take you to the regular Sort dialogue window. If your cells are color coded, you can choose to sort them that way as well. However, the Sort dialogue will also let you sort as usual (by values on several different levels).
Below that, you’ll find a “Clear Filter From?” choice. That’s only active if a filter is applied to the current column and would remove the filter from that column only. It does not turn off the AutoFilter.
“Filter by Color” will be available if the cells in that column have been colored. In that case, choosing this option shows you a simple palette of colors in the data for you to pick from, like this:
Also, while we’re still looking at the picture above, you may have noticed that the Number Filters have been replaced with “Text Filters.” That’s because the data column contains text instead of numbers. Here are the choices you’ll find for filtering text:
All of them open the Custom AutoFilter dialogue window. The difference between choosing “Custom Filter” and the rest is with the other choices, Excel places the chosen arguments in the Custom AutoFilter dialogue window for you.
You may have noticed that the “Number Filters” choice has quite a bit to it as well.
The upper two sections do the same as the Text Filters. They simply open the Custom Filter dialogue with the correct arguments in place. If you see one you’re going to use anyway, you might as well let Excel do the work for you.
Now, between the “Top 10″ and “Custom Filter” options we covered the other day, you will find “Above Average” and “Below Average.” Those do exactly what you would expect them to do. It averages your numeric data and then filters for the above or below choice you made.
There you have it. Quick and easy AutoFilter extras for Excel 2007!