Tag Archives: Auto Filter

The very hidden gem of AutoFilter in #Excel

Posted on May 30, 2021 by MF

Don’t get me wrong. I am not talking about the Filter button sitting on the Data Tab of ribbon, although they look almost exactly the same. I am pretty sure that most people who use Excel five days a week … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

#Excel Add current selection to filter. What it does?

Posted on April 7, 2019 by MF

Get multiple filter criteria with Excel Auto-Filter This post is in response to the following Mr.Excel video where Mr. Excel Bill Jelen solved the problem with Advanced Filter. Indeed I got a similar question from a colleague recently for filtering … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

Hidden Rows vs. Filtered Rows

Posted on June 13, 2015 by MF

One day, a friend asked me: “If she deletes contents from a filtered range, would she also delete the hidden content?”  I answered: “Try and observe!” 😛 I know that is not the answer she expected.  Nevertheless, I believe that … Continue reading →

Rate this:

Posted in Excel Basic | Tagged , | 1 Comment

Date Filter is good, but still with limitation

Posted on May 30, 2015 by MF

This is about how to filter a particular date, say 1st of January regardless year, from a list of dates. As a matter of fact, not many people are aware of the Date Filter feature in Excel.  This is true at … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Interesting bug – Filter with SUBTOTAL

Posted on May 16, 2015 by MF

In the process of writing my previous post, I found something wrong with Filter…  when Column A contains formula starts with SUBTOTAL, Auto Filter refuses to take the last row.

Rate this:

Posted in Excel Tips | Tagged , | 4 Comments

Sequential number for visible rows only

Posted on May 9, 2015 by MF

How to display a column of sequential number to visible rows only? Got this question from a friend.  Her task is simple as shown below: I guess many people wanted to achieve the same thing but have no idea at all.  Are … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , | 26 Comments

Keyboard shortcut tip – Filter by selection with Menu Key

Posted on April 25, 2015 by MF

You may have no idea about the shortcut key combinations above (the middle clip art is not a key combination, ok?!).  That’s normal, I guess.  Most of the time we talk about keyboard shortcuts, we think about Ctrl or Alt. … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged , , | 5 Comments

Why do you turn off Auto Filter and then turn it on again??

Posted on January 30, 2014 by MF

I have seen many people turning OFF and then ON Auto Filter in order just to SHOW ALL values (in Excel 2003’s terms) or CLEAR all filters (in Excel 2007 or above’s terms).  Frankly, I think many people do this … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment