Delete rows

[John Davis]

Hello All:

I have a spreadsheet, I want to highlight a section and delete every other row. Can someone advise the best way to accomplish this. All help is appreciated.

 

[CharlesAlvear]

Re: Delete alternate rows

Here's my non-fancy way of doing it:

- Insert a new column (so that you have a new Column A which is blank)
- in the first four cells of Column A, enter 0, 1, 0, 1
- then expand this series of 0s and 1s to span your entire spreadsheet so that you have a series of alternating 0s and 1s in column A
- Sort your spreadsheet by column A
- then delete all your rows that have 0s or 1s (whichever contains the data you do not want).
- then resort the range by column A again so that your remain data sorts to the top of the sheet (in case your data was in the rows that contained 0s).

I'm sure there is a way to program a macro or VBA code to do this, but that's my layman's method.

Good luck!

 

[John Davis]

Re: Delete alternate rows

Here's my non-fancy way of doing it:

- Insert a new column (so that you have a new Column A which is blank)
- in the first four cells of Column A, enter 0, 1, 0, 1
- then expand this series of 0s and 1s to span your entire spreadsheet so that you have a series of alternating 0s and 1s in column A
- Sort your spreadsheet by column A
- then delete all your rows that have 0s or 1s (whichever contains the data you do not want).
- then resort the range by column A again so that your remain data sorts to the top of the sheet (in case your data was in the rows that contained 0s).

I'm sure there is a way to program a macro or VBA code to do this, but that's my layman's method.

Good luck!

Thanks Charles. That's exactly what I was looking for, an approach, which wouldn't take much time. However, unfortunately, I decided to write the code too delete. Oh well, I'll try and remember this one the next time.