My wife was working on her Excel doing some of her unfinished work at home and notice that excel filter delete hidden rows and she was going crazy about this issue.

I tested it and true indeed when she set the excel filter, she only delete those visible rows only.

Further test shows that when she right click the mouse, sometime it appear the Delete (will delete all including the hidden rows) options and other times it shows the Delete Rows option which is supposed to be the correct one.

Solution:

This is excel filter delete hidden rows bug can be fixed with the following hotfixed link:

http://support.microsoft.com/kb/948944/

This article describes the Microsoft Office Excel 2007 issues that are fixed in the Excel 2007 hotfix package that is dated February 18, 2008.

Notes:

After installing the hotfixed, remember to shutdown and restart your computer.

Back To:
GoToThings - Knowledge Sharing