Delete rows in a spreadsheet

  • Thread starter Jeffrey Gertner
  • Start date
J

Jeffrey Gertner

Hi all,
I received a spreadsheet which has a blank row on evey other line. I am
trying to figure out how to delete the blank rows. The sheet has 6000 lines
of information and 6000 lines of blank information. Is there a way to write
a formula to delete the blank rows.

Thanks for any help
Jeffrey
 
D

Dave Peterson

You could apply Data|filter|autofilter and filter to show only the blank rows.
Then delete those blank rows.

Or maybe you could just sort your data and then delete the blanks all at once.
 
Top