Forum Discussion
how to delete every other line in excel work sheet
how do i delete every other line in a worksheet?
You might enter the formula =ISODD(ROW(A1:A1000)) in a cell in row 1 of an empty column.
You can then filter on TRUE or on FALSE depending on which rows you want to delete, then delete the visible rows.