Excel Tip- Deleting Multiple Rows

An article by Darin Wagner    No Comments

A colleague asked me how to delete every second row of data in an Excel spreadsheet that contains thousands of rows. Manual deletion in this case (holding the CTRL key on a PC) while selecting every second row would take too long.

A quick search turned up this tip in the Excel Forum.

1. Insert a “helper” column to the left of the first column.
2. Enter this formula: =mod(row(),2)
3. Copy down the formula to the end of the data rows. A column with ones and zeros should appear.
4. Use the Filter to filter all of the data and select the value that you don’t want.
5. Delete all the rows with that value.
6. Clear the Filter.
7. Delete the “helper” column.

Hope this helps someone!