Deleting Rows
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
|