The fastest way to delete every other row

Select the rows you want to remove, then delete them all at once. In Excel, you do this by clicking the row number on the left side while holding Ctrl (or Cmd on Mac), which lets you pick multiple non-consecutive rows. Once all the rows you want gone are highlighted in blue, right-click and choose Delete.

The catch is that Excel does not have a built-in "delete every other row" button. You have to either select them manually one by one, or use a helper column with a formula to mark which rows to keep, then filter and delete. For small spreadsheets, manual selection is faster. For large ones with hundreds of rows, the helper column method saves time.

Key Takeaways

  • Manual selection works best for spreadsheets under 50 rows: click row 2, then Ctrl+click row 4, row 6, and so on, then right-click and delete.
  • For larger spreadsheets, add a helper column with a formula like =MOD(ROW(),2)=0 to mark every other row, then filter and delete in one step.
  • Always copy your spreadsheet to a new file before deleting rows, in case you need to undo the change later.
  • Deleting rows shifts all the rows below them up, so row numbers change as you delete — this is why selecting all rows first, then deleting, is safer than deleting one at a time.

Manual selection for small spreadsheets

If your spreadsheet has fewer than 50 rows, clicking each row individually is the most straightforward approach. Start by clicking the row number 2 on the left side of the spreadsheet. The entire row will highlight in blue.

Now hold down Ctrl (Cmd on Mac) and click row 4. Row 4 will also highlight. Keep holding Ctrl and click row 6, then row 8, and continue until you have selected every other row. You will see all of them highlighted in blue at the same time. Once you have selected all the rows you want to remove, right-click on any of the highlighted rows and choose Delete from the menu. Excel will remove all of them in one action.

Using a helper column for large spreadsheets

For spreadsheets with hundreds of rows, manual clicking becomes tedious and error-prone. A helper column lets you mark which rows to delete, then remove them all at once. Start by clicking on a blank column to the right of your data — often column D or E if your data ends in column C.

In the first cell of that column (let's say D1), type the formula =MOD(ROW(),2)=0. Press Enter. This formula returns TRUE for every even-numbered row and FALSE for every odd-numbered row. Click on that cell again, then drag the small square at the bottom-right corner of the cell down to the last row of your data. The formula will copy down and mark every other row as TRUE.

Now click on any cell in your data, then go to the Data menu and choose AutoFilter. Small dropdown arrows will appear in the header row of each column. Click the dropdown arrow in your helper column and select only TRUE, then click OK. Your spreadsheet will now show only the rows marked for deletion. Select all visible rows (click the first row number, then Shift+click the last visible row number), right-click, and choose Delete. When you turn off the filter by going back to Data > AutoFilter, the remaining rows will be visible and the others will be gone.

Why row numbers matter when deleting

When you delete a row in Excel, every row below it moves up by one. If you delete row 2, what was row 3 becomes row 2. This is why deleting rows one at a time from top to bottom can cause you to skip rows or delete the wrong ones — the row numbers shift as you go.

This is why selecting all the rows you want to delete first, then deleting them all at once, is safer. Excel removes them all in a single operation, so the shifting does not cause confusion. If you must delete rows one at a time, always delete from the bottom up (highest row number first) so the rows below do not shift into the rows you have not yet processed.

Protecting your original data before you delete

Before you delete any rows, save a copy of your spreadsheet with a different name. Go to File > Save As, type a new name like "Original Data Backup", and click Save. This way, if you delete the wrong rows or change your mind, you still have the original file.

After you have made your backup, you can work on the original file without worry. If something goes wrong, you can always close the file without saving and start over with the backup. This is especially important if you are deleting a large number of rows or working with data you cannot easily recreate.

Undoing a deletion if you made a mistake

If you delete rows and when ready realize you made a mistake, press Ctrl+Z (Cmd+Z on Mac) to undo. Excel will restore the rows you just deleted. You can undo multiple steps in a row by pressing Ctrl+Z repeatedly, which takes you back through your recent actions one by one.

However, undo only works while the file is still open. Once you close the file without saving, the deletion is permanent. This is why keeping a backup copy is important — if you close the file and then realize you deleted the wrong rows, you can open the backup and try again.

Frequently Asked Questions

Can I delete every other row starting from row 1 instead of row 2?

Yes. Instead of selecting row 2, start by clicking row 1. Then Ctrl+click row 3, row 5, row 7, and so on. The helper column method also works: the formula =MOD(ROW(),2)=1 marks odd-numbered rows instead of even-numbered ones.

What if I want to delete every third row instead of every other row?

Use the helper column method with the formula =MOD(ROW(),3)=0. This marks every third row. You can change the number 3 to any interval you want — =MOD(ROW(),4)=0 marks every fourth row, and so on.

Does deleting rows affect formulas in other cells?

Yes. If a formula in another cell refers to a deleted row, that formula will show an error. Before you delete rows, check whether any other cells contain formulas that reference them. If they do, you may need to update those formulas or copy the data you need before deleting.

Can I delete every other row in Google Sheets the same way?

The manual selection method works the same way in Google Sheets. The helper column method also works, but Google Sheets uses slightly different menu names — look for Data > Create a filter instead of AutoFilter. The formulas are identical.