Deleting blank rows en mass

[Colin _wales]

I'm copying a large amount of data from the internet and when I put the
pages into a workseet I have every other row blank. The only way I can
seem to get rid of the blank rows is to hold down the ctrl key and
highlight them. -- This takes an age... Is there any way I can use a
function to auto delete all the blank rows ??

 

[Ken Wright]

You don't mention any problems with the data, but just in case, I always keep a copy of Dave
McRitchies Trimall macro in my personal.xls. Run it against your data and it will clear out any
garbage such as leading.trailing spaces, non breaking spaces etc.

As to the blank lines, select any column from start of data to end, do Edit / Go To / Special /
Blanks, then hit Edit / Delete / Entire Row.

 

[Andy Brown]

Highlight an entire column, then Edit -- Go To -- Special -- Blanks -- OK.
Then Edit -- Delete -- Entire Row -- OK.

Rgds,
Andy

 

[Ken Wright]

LOL - The link might have been more help than just the advice:-

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

You don't mention any problems with the data, but just in case, I always keep a copy of Dave
McRitchies Trimall macro in my personal.xls. Run it against your data and it will clear out any
garbage such as leading.trailing spaces, non breaking spaces etc.

As to the blank lines, select any column from start of data to end, do Edit / Go To / Special /
Blanks, then hit Edit / Delete / Entire Row.