Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
Easiest way to find differences between Rows? | Excel Discussion (Misc queries) | |||
Easiest and quickiest way to delete blank pages in a worksheet | Excel Discussion (Misc queries) | |||
Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |