99.4% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
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?
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.
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?
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.
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.