Once the rows are selected, a single stroke on the Delete button is all it takes.
Highlight Every Other Row in Excel using Conditional Generally, deleting every other row in Excel boils down to selecting alternate rows. Highlight EVERY Other ROW in Excel (using Conditional Formatting), Here are the steps to highlight every alternate row in Excel: Select the data set (B4:D15 in this case). The easiest way to select alternate cells, in a column is by creating a new temporary column next to your target cell and using Selection offset in the Method 1: Using Go to Special and Selection Offset. Now let’s jump into some methods you can use to select every other cell in a column in Excel. Once the rows are selected, a single stroke on the Delete How to Select Cells in Every Other Row. How to delete every other row or every Nth row in Excel, Generally, deleting every other row in Excel boils down to selecting alternate rows.
