deleting every other row in Excel

R

RuthZ

I have a spreadsheet with copy and pasted information. The information
includes a blank row between data rows. Is there a formula I can use to
eliminate the blank rows?
Thanks,
RuthZ
 
G

Gord Dibben

Select a column then F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
Top