How to easily remove all blank rows within a defined range in an Excel 2010 spreadsheet (via The IT Bod)

How to easily remove all blank rows within a defined range in an Excel 2010 spreadsheet I came across this problem whilst importing a large amount of data that contained two blank rows for every row that contained data. First select your data that contains the blank rows Then click on the Home tab and select Find & Select. Now select Go To Special In the Go To Special dialogue box select Blanks and OK This should highlight the blank rows within your selected range Click on the Home tab again. Select Delete and Delete Sheet Rows … Read More

via The IT Bod

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s