Delete rows in a spreadsheet

[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

 

[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.