How can Excel select blanks?

Excel can select any blank (empty) cells in a region by the following:

1. Select the appropriate region on your spreadsheet.

2. From the Home tab, select the Find & Select button in the Editing group click the 'Go To Special' link.

3. Then select Blanks and click OK.

(In Excel 2003 click Edit menu, Go To, Special... button, then select Blanks, click OK).

Other posts you might be interested in:

Access/Excel

What is the easiest way to remove errant spaces/letters etc from cells in numeric spreadsheets you have had to import from a different format? From the beginning and from the end of cells. Thanks.
Read forum post

Fill Blank rows with data in cell above

I am trying to fill blank rows with data from the row above. I would like to avoid a loop mechanism as this will take some time to run. Whenever I attempt to use Go To > Blanks and use RC -1 formulae excel informs me that the selection is too large. Is there any way around this?
Read forum post

Sorting Out Your Data In Excel

Learning how Excel can sort your data for you, and knowing how to use filters, can be a great advantage in avoiding cluttered up spreadsheets. It also makes them more user friendly and easier for other people to find what they want, if you’re sharing your data.
Read article

Training courses