asked on

MS Excel 2007 - Removing Blank Rows

Hi

I have imported a rather large chunk of data and througout the data there are rows of blank rows (empty)

I would like to in the easiest way possible remove the blank rows from the data as the amoutn if data is quite a lot. Otherwise it will be a right click and delete row which will take me ages

I remember in 2003 that you could highlight the whole table, F5 and then right click delete rows but in 2007 I cant seem to do that

Thanks

SOLUTION

jppinto

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

tilsant

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Rory Archibald

You could just sort the data - blank rows will end up at the bottom.

tilsant

Just to check that you have not lost any data, do a count on non blank cells before and after doing the above steps.

Saqib Husain

Rory, wouldn't this change the sequence of the data?

Rory Archibald

Might do, might not. No way to tell from the question whether it would, or whether that's important. :)

tilsant

and even if that changes the sequence, one can always give numbering to the initial data (in some helper column), then remove the blanks by Rory's method and then sort on the Helper Column again, to get the initial sequence.

tilsant

In fact, if we use a Helper column, then we can use the standard autofilter function and filter for Blanks and then delete.
SS.JPG

SOLUTION

Rob Henson

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer