How To Select Blank Cells within a worksheet

R

Roxanne

How would I select blank cells within a worksheet?

Somebody told me the steps are
Edit
Go to
Special (under the menu option)

But when I did this all of the Blank cells were not selected, but most were.

Thank you for any help.
 
P

Pete_UK

You might want to try this variation:

Click in an area where your data is, then F5 (same as Edit | GoTo)
then click Special then click Current Region. Then F5 again, Special,
Blanks.

Hope this helps.

Pete
 
G

Gord Dibben

Roxanne

That command will select blank cells only in the used range of the sheet, not
the entire sheet.


Gord Dibben MS Excel MVP
 
R

Roxanne

Thank you very much!
Gord Dibben said:
Roxanne

That command will select blank cells only in the used range of the sheet, not
the entire sheet.


Gord Dibben MS Excel MVP
Click to expand...
 
Top