Deleting Rows

  • Thread starter Thread starter globalsaint
  • Start date Start date
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
 
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.
 
Try this

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

Mike
 
Without sorting...................

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top