View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
childofthe1980s childofthe1980s is offline
external usenet poster
 
Posts: 122
Default automatically deleting blank rows?

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