Tag Archives: Bug

Limitation (or bug?) with Filter by Color

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

Bug with copy and paste in Excel Table

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

Rate this:

Posted in General | Tagged | 22 Comments

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