How to Delete every other Row in Excel

In this video tutorial we will show you how to delete every other row in excel.

Open the excel document you want to edit. In blank column besides original data, enter 1,0,1,0,1,0,1,0…1,0.


Enter repeated numeric values

Select this column and choose “Sort&Filter”. Click on “Filer” button in popup menu.

Choose Filter

Click on the arrow button besides first row, and uncheck “Select all” option and check “0” button and press “ok”. Now you can see that all rows with “1” are hidden.

Set Filter parameters

Now select all rows with “0” and click “Delete”, and choose “Delete sheet rows”. It deletes every other row and shows only the rows with 1.

Delete rows