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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete a group of alternate cells
I would use a helper column.
Put X in a row 17 of that helper column (say Z). Select Z17:Z18 copy it down to row 709 Select that range edit|goto|special|check constants and click ok edit|delete|entire row (Save before you try it--just in case) poleary53 wrote: 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 -- Dave Peterson |
Reply |
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) |