Thread: Delete Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Bill is offline
external usenet poster
 
Posts: 390
Default Delete Rows

For Excel 2007

I would like to delete rows from a worksheet. As example, I would like to
delete rows 1, 2, 4, 5, 7, 8, and so on. I would like to keep rows 3, 6, 9,
and so on. In this example, I am deleting two consecutive rows. I may want to
delete 3 consecutive rows in another application.

I would like to delete these rows in the easiest manner possible, without
deleting each row individually.

Any suggestions are appreciated.

Thank you