Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

One More Filter Discussion: For Excel 2007

Monday, August 4th, 2008 by | Filed Under: MS Excel, MS Office Help

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!

~ April

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive