automatically deleting blank rows?

  • Thread starter Thread starter childofthe1980s
  • Start date Start date
C

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
 
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
 
Thanks, Peo!!!

childofthe1980s

Peo Sjoblom said:
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
Click to expand...
 
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?
 
Back
Top