Delete Rows

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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.
 
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
 
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
Click to expand...
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
 
Back
Top