Delete Rows

[Bill]

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

 

[marysully]

Try clicking each row header for the rows you want to delete while holding
down the ctrl key. Once the rows are selected, right click and then Delete.
You can also do Edit, and Delete. I think it works best if you do a few rows
at a time.

 

[Bill]

I knew what you suggested but I was looking for an easier way. If I had a
1000 rows, this would take considerable time.

Thank you

 

[Bill Sharpe]

I knew what you suggested but I was looking for an easier way. If I had a
1000 rows, this would take considerable time.

Thank you

It's going to take some time unless you have a repeatable pattern of
rows to delete, in which case you could record a macro to automate the
process.

I use a simple macro that deletes the row with a cell selected with one
keystroke combination.

See "record macro" in Excel help.

Bill