filter-->blank and Isblank() and Go special -->Blank() are not in sync!

[lezawang]

Hi I am reading an article about deleting blank cells. The author suggested to use filter-->blank (see below please). So I tried it on a column which has some blank cells and it did work. Then I did undo that and went to Go Special-->Blank, to highlight them, but excel did not highlight them!! then I used IsBlank() and all are False. Now I wonder why Filter-->Blank deleted them while IsBlank() and Go Special are saying they are not blank cells?

Thanks



[h=2]8. Speedily Delete Blank Cells[/h]Some default data will be blank, for various reasons. If you need to delete these to maintain accuracy, especially when calculating the average value, the speedy way is to filter out all blank cells and delete them with one click. Choose the column you want to filter, go to Data->Filter, after the downward button shows, undo Select All and then pick up the last option, Blanks. All blank cells will show immediately. Go back to Home and click Delete directly, all of them will be removed.

 

[footoo]

The filter treats cells that contain "" as a result of a formula and cells that contain spaces only as blank.
SpecialCells and ISBLANK do not treat them as blank.