Tag Archives: Bug

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

Bug with copy and paste in Excel Table

Posted on November 21, 2015 by MF

Do check what you do! On top of human errors, there may be bug hidden. Continue reading →

Rate this:

Posted in General | Tagged | 50 Comments

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