worksheet with 2000 rows.
I would like to keep rows 3, 6, 9, and so on.
Also, I would not want to write a macro if possible.

One of many ways, although a custom macro is the easiest.

Assume Data in Columns A:D, and the first empty Column is E:E
Place an 'x in E3.

Type E1:E2000 in the name box to select the range.
Select Home | Editing | Fill | Series ...

Select Type "Autofill"

Select F5 | Special | Blanks

Right Click a cell | Delete... Entire Row

Clear Column E:E

= = = = = = = = =
HTH :)
Dana DeLouis



On 2/5/10 11:03 PM, Bill wrote:
For Excel 2007

I would like to a repetitive pattern of rows delete rows from a very large
worksheet with 2000 rows. 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, keeping the next row, deleting
the next two rows, keeping the next row, and so on. There is a pattern of
deleting rows.

I would like to delete these rows in the easiest manner possible, without
deleting each row individually. Also, I would not want to write a macro if
possible.

Any suggestions are appreciated.

Thank you