Tag Archives: Filter

Replace values in filtered ranges using Copy and Paste trick in #Excel

Posted on November 14, 2020 by MF

Situation: In a filtered range of data, we made few changes on the side. Then we want to replace the original values with the updated values. What action appear on top of your mind? Copy and Paste of course. But… … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Filter a list of items from a long long list

Posted on August 2, 2017 by MF

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 MF

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 MF

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 | 32 Comments