24. Excel How to delete every other row ?

---

Consider the following list of cities. We want to delete every second row of this list, i.e. rows 3, 5, 7, 9, etc....

Proceed as follows:

1 - Write in cell C3 "delete"

2 - Select the range of cells C2:C3 and copy this range by Autofill to the last line of your sheet.

3 - Then filter column C with the value "delete".

4 - Select all filtered rows and delete them.

5 - Cancel the filter. Also delete the utility column C.

---