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).

Related forum posts:

Excel

In a long series of dates in a column how can I eliminate blank rows not containing any information without selecting and delating one by one?

Read forum post

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

Related articles

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

98.7 % recommend us More live stats...