Thread: Deleting Rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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