You can quickly do this by typing 0 in the first cell and 1 in the second cell, then copying the first two cells and pasting them down the column until the last cell with data. In essence, a common way to erase every other row in Excel is this: first, you filter alternate rows, then select them, and delete all at once. How to delete every other row in Excel by filtering Further on in this article, you will learn a few techniques to quickly select and delete every other or every Nth row in Excel. Once the rows are selected, a single stroke on the Delete button is all it takes. Generally, deleting every other row in Excel boils down to selecting alternate rows. For example, you might want to keep data for even weeks (rows 2, 4, 6, 8, etc.) and move all odd weeks (rows 3, 5, 7 etc.) to some other sheet.
There are many situations when you may need to delete alternate rows in Excel worksheets. You will also learn how to remove every 3 rd, 4 th or any other Nth row.
This short tutorial explains how to delete every other row in Excel by filtering or with VBA code.
