How can Excel select blanks?

TrustPilot

starstarstarstarstar Excellent

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:

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

 

 

Live dates & prices

 

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.


TrustPilot
TrustScore 9.6       1034 reviews