Deleting Rows

G

globalsaint

Does anyone know how to delete every other row without going row by row? I
imported a financial report and every other row is blank. I would like to
highlight the whole report and delete every other???

Thanks,
Marino
 
D

Dave Peterson

Could you just sort your data?

Heck, if the blank rows sorted at the top, you could just delete that one group
of rows.

Another way -- if you can pick out a column that always has data when the row
has data.
Select that column
Data|filter|autofilter
Filter to show the empty cells
Delete those visible rows
Remove the filter.
 
M

Mike H

Try this

Select all of column A
Press F5, Special, Blanks, OK
Press Ctrl-Minus and Entire Row.

Mike
 
G

Gord Dibben

Without sorting...................

Select a column then F5>Special>Blanks>OK>Edit>Delete>Entire Rows


Gord Dibben MS Excel MVP
 
Top