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.

globalsaint wrote:

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

--

Dave Peterson

Try this

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

Mike


"globalsaint" wrote:

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

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

Select a column then F5SpecialBlanksOKEditDeleteEntire Rows


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 13:44:01 -0700, globalsaint
wrote:

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