You can do it manually but still pretty fast, select the range, then press
F5, click special and select blanks,
do editdelete and select entire row


--


Regards,


Peo Sjoblom


"childofthe1980s" wrote in
message ...
Hello:

I exported data from Crystal Reports to Excel. I have a huge spreadsheet,
and a lot of blank rows in between records of data.

Is there a way to "tell" Excel to get rid of any and all blank rows,
rather
than having to manually go through the tens of thousands of rows of the
spreadsheet to find and delete rows?

childofthe1980s