Tag Archives: Filter

Filter a list of items from a long long list

Posted on August 2, 2017 by

A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my favorite Excel sites) last week.  In his post, he showed how to filter for a list of items using a reverse … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 5 Comments

Limitation (or bug?) with Filter by Color

Posted on January 30, 2016 by

Did you know that you can filter by color since Excel 2007?  Yes, that’s almost 10 years.  I wont’ say it is a new feature notwithstanding the fact that many people are not aware of it yet. 😛 Filter by … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 16 Comments

Where are Filter drop-down buttons?

Posted on May 23, 2015 by

Have you ever encountered a filtered range without Filter drop-down buttons available on the top?  No idea what I am talking about?  Take a look at the following screenshot. Without the Filter buttons on the top, I tried to show hidden … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 30 Comments