Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I have found, in a number of my workbooks, ranges that contain cells that appear to be blank, but excel treats them as though they have data. When I sort a column ascending, these cells end up at the top of my list. Selecting and clearing them removes whatever value is hidden there and they no longer sort to the top of my lists. I'd like to be able to find them and clear all of them in my workbook but I can't figure out how to "find" them. Thoughts? Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A formula to "clear to zero" multiple cells | New Users to Excel | |||
If Cell = "XXX" Then clear all other cells formula | Excel Worksheet Functions | |||
How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
"Invalid property" after "Clear Form" | Excel Programming | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |