Easiest Way to Delete Rows
I would use the Data Filter. If your data is such that you can filter out
the rows you want to keep, then do so, and delete the visible rows.
If not, insert a column with the formula:
=if(mod(row(),3)=0,"Keep","Delete")
Then use Data Filter to select the "Delete" records, and delete them.
Regards,
Fred
"Bill" wrote in message
...
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
|