How can Excel select blanks?

Forum home » Topics » How can Excel select blanks?

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:


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:


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


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.08 secs.