How to Delete Every Other Row in an Excel Worksheet
Question details
The user needs a reliable method to remove alternating rows (every other row) safely from a dataset in Excel.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Cleaning up and editing large datasets by targeting alternating rows for deletion without doing it manually.
- Observed behavior
- The user requires an automated or structured approach to accurately identify and delete odd or even rows simultaneously.
Before making bulk deletions, ensure you create a backup of your worksheet so that you can easily recover the data if the wrong rows are accidentally removed.
Use a Helper Column with ISODD or ISEVEN Formulas
This is the most reliable method for targeting every other row. It uses a helper formula to identify odd or even rows and Excel's filter tool to isolate them for deletion.
Add a new, empty column next to the dataset you want to clean up, and label the header as 'Helper'.
In the first cell of the Helper column, type =ISODD(ROW()) to flag odd-numbered rows, or =ISEVEN(ROW()) to flag even-numbered rows.
Select the cell with the formula and double-click or drag the fill handle down to copy the formula across all the rows in your dataset.
Click the Helper column header, navigate to the 'Data' tab on the ribbon, and click 'Filter'. Click the filter drop-down icon in the Helper column header and select only the 'TRUE' checkbox.
Highlight all the visible rows displaying TRUE, right-click any highlighted row number on the left side, and choose 'Delete Row'. Afterward, clear the filter and delete the Helper column.
Use a Number Sequence and Filter
A simpler alternative that does not rely on formulas. It uses a repeating number sequence to separate rows.
Automate Deletion Using a VBA Macro
For advanced desktop users, a VBA macro can automatically delete alternating rows in one click without requiring helper columns.
Quickly Delete Alternating Rows in WPS Spreadsheet
WPS Spreadsheet offers powerful data filtering tools, a full library of formulas, and an intuitive interface that makes cleaning up datasets incredibly easy.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the Excel workbook containing your dataset.
- 2. Set up the helper column: Add a new column and enter =ISODD(ROW()) in the first cell, then fill it down the rest of your data.
- 3. Filter and delete: Go to the 'Data' tab, click 'AutoFilter', and filter the column for TRUE. Highlight the visible rows, right-click, and choose 'Delete'.

Frequently Asked Questions
Can I use this method to delete every third or fourth row?
Yes, you can modify the helper column formula. To target every third row, you can use a formula like =MOD(ROW(), 3)=0. This will return TRUE for rows that are multiples of three, which you can then filter and delete.
Why can't I run a VBA macro to delete alternating rows in Excel for the web?
Excel for the web does not currently support the execution of VBA macros. To use macros, you must open your workbook in a compatible desktop version of Excel or use the helper column and filter method instead.
Does deleting filtered rows affect hidden data?
No. When you highlight visible rows after applying a filter in Excel and choose to delete them, the action safely removes only the filtered rows. The hidden (unfiltered) data remains completely intact.
Will the ISODD function work properly if I sort the data first?
The ISODD(ROW()) function dynamically evaluates the row number it currently occupies. If you plan to sort your data, it is recommended to copy the helper column and paste it as 'Values' before applying any filters or sorts so the TRUE/FALSE results do not shift.




