Here's our Microsoft Office Tip for.. June 6, 2006
Click Here to see a complete list of all of our previously released Tips!
Finding Blank Cells
You can use the Go To Special command to select all the blank cells in the active worksheet. First, press F5 to display the Go To dialog box.
Then, click the Special button in the bottom-left corner. In the Go To Special dialog box, select the Blanks option and click OK. Excel will highlight all the blank cells.
If you have a blank cell that Excel doesn't select, you might suspect that the cell's simply hidden--but you'd be wrong. You can't use the Go To Special command when your worksheet is protected. Check the cell carefully to make sure it's really not full of spaces. Truthfully, it'll be hard to tell, so try this: Select the cell and press the Delete key. Then, try selecting all the blank cells again. More than likely, the Go To Special command will work after you delete the cell's unseen contents.