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

image001

Then click on the Home tab and select Find & Select. Now select Go To Special

image002

In the Go To Special dialogue box select Blanks and OK

image003

This should highlight the blank rows within your selected range

image004

Click on the Home tab again. Select Delete and Delete Sheet Rows

image005

This removes the blank rows and maintains any formulas

image006

Advertisements

4 thoughts on “How to easily remove all blank rows within a defined range in an Excel 2010 spreadsheet

  1. Pingback: How to easily remove all blank rows within a defined range in an Excel 2010 spreadsheet (via The IT Bod) | Excel for Fantasy Football

  2. Pingback: How to easily remove all blank rows within a defined range in an Excel 2010 spreadsheet (via The IT Bod) | Excel for Fantasy Football

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