delete blank rows
 

I have an excel spreadsheet sent to me that contains blank rows. Is there a
way to get rid of the blank rows with a formula so I don't have to go through
and delete. There are over 2000 rows with blanks inbetween each row of text.

Thanks,

delete blank rows
 

If you set up Autofilters then you can filter one column for (blanks),
then highlight all the blank rows which are displayed (row identifier
turns blue) and Edit | Delete Row in one operation. Select (All) from
the filter pull-down list and all your blank rows will have gone.

Hope this helps.

Pete