Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete a group of alternate cells
How would I delete every other row in a spreadsheet? My data starts on row 16 ends on row 709. I want to start deleting every other row starting with row 17. i.e.; Delete rows 17, 19, 21, ... all in one key stroke. Thank-you Pat O'Leary -- poleary53 ------------------------------------------------------------------------ poleary53's Profile: http://www.excelforum.com/member.php...o&userid=32234 View this thread: http://www.excelforum.com/showthread...hreadid=519899 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should allow delete cell's value but leave formula alone. | Excel Discussion (Misc queries) | |||
Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
delete group box | Excel Discussion (Misc queries) | |||
how to change a formula for a large group of cells | Excel Worksheet Functions | |||
Delete shaded cells | Excel Discussion (Misc queries) |