Reapply Filter in #Excel

Did you notice that there is a “Reapply” button next to Filter on the Data Tab of ribbon? And wondering what it does? 🤔

Indeed, the “Reapply” button is dim until you have applied filter to at least one column.

To illustrate how to “Reapply” filter, let’s start with a simple example.

Situation

We have applied a filter on Market to show records of “HK” only, as shown below:

Then we realized that the Shop “A004” should belong to “SG” market, so we revise the data on the spot…

However, filter is not dynamic. In order to filter out the record of A004, which we have just revised it to SG Market, we have to reapply the filter again.

(If you are using Excel 365 and want to have dynamic filter, check out the new FILTER function)

Here comes the “Reapply” button to rescue!

As simple as this. 😉

You may be thinking… it requires two clicks (first click on Data; second click on Reapply). Why don’t we simply set the filter from the filter pull down? It takes two clicks only too.

Well… you are absolutely right when you are only dealing with one column. What if when we have filters set on multiple columns? The number of clicks would be a multiplication of 2 and the number of columns with filter set. That makes the difference. Right?

Having said that, if two-clicks is a concern to you, let’s use the keyboard shortcut:

Ctrl+Alt+L

How do I know this shortcut? Excel told me. 😁

Excel shows tips in subtle way… what Excel needs from us is our attention!

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.