Delete rows in a spreadsheet

  • Thread starter Thread starter Jeffrey Gertner
  • Start date 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
 
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.
 
Back
Top