One way if they are truly blank, select the range, press F5, select special,
select blanks, press OK. Do editdelete or press ctrl + -, select entire row
and press OK


Regards,

Peo Sjoblom


"Edgar" wrote in message
...
I pasted a large document from Word into Excel. Everything worked perfectly
but now I need to remove the blank lines that became empty rows. I suspect
a
macro would accomplish this but I have never programmed a macro in Excel.
--
-Edgar