smittycft99
Board Regular
- Joined
- Apr 16, 2002
- Messages
- 128
I have a large xls, with 4000 rows. How can I quickly delete every odd row, 1,3,5,...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to delete odd rows?
- Thread starter smittycft99
- Start date
shades
Well-known Member
- Joined
- Mar 20, 2002
- Messages
- 1,550
Are your rows numbered?
I have found ASAP-Utilities to be excellent for this.
http://www.asap-utilities.com
After you download (free) and install, then in the ASAP menu, go to Columns/Rows, and select the first item ("Conditional Row and Column, select, hide or delete"). The options are clear.
_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-06-13 06:23
I have found ASAP-Utilities to be excellent for this.
http://www.asap-utilities.com
After you download (free) and install, then in the ASAP menu, go to Columns/Rows, and select the first item ("Conditional Row and Column, select, hide or delete"). The options are clear.
_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-06-13 06:23
Upvote
0
Similar threads
- Solved
