Thread: Deleting Rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Deleting Rows

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