Deleting blank rows en mass

  • Thread starter Thread starter Colin _wales
  • Start date Start date
C

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 ??
 
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.
 
Highlight an entire column, then Edit -- Go To -- Special -- Blanks -- OK.
Then Edit -- Delete -- Entire Row -- OK.

Rgds,
Andy
 
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
----------------------------------------------------------------------------



Ken Wright said:
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.
Click to expand...
 
Back
Top