Tag Archives: Auto Filter

Hidden Rows vs. Filtered Rows

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 , | Leave a comment

Date Filter is good, but still with limitation

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

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 , | 3 Comments

Sequential number for visible rows only

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 , | 10 Comments

Keyboard shortcut tip – Filter by selection with Menu Key

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??

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