Thread: Deleting Rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Deleting Rows

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