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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks