Forum Discussion
how to delete every other line in excel work sheet
how do i delete every other line in a worksheet?
Are the lines you want to delete blank lines--no data at all? You could use the FILTER function to extract rows that contain stuff and set the result as the new data set.
It would help, though, if you described the situation a bit more fully, since other wise you're asking us to guess what's going on, what is characteristic of the rows to be retained, and/or of the rows to be deleted.