automatically deleting blank rows?

[childofthe1980s]

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

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[childofthe1980s]

Thanks, Peo!!!

childofthe1980s

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


--


Regards,


Peo Sjoblom

 

[David Biddulph]

But wouldn't that also delete any rows in which *any* cells were blank?
Didn't the OP want to delete just the blank rows?