Document Editing Problems

How to Delete Every Other Row in an Excel Worksheet

Aamir Naveed AkramAamir Naveed Akram Nov 10, 2026 869 views

Question details

The user needs a reliable method to remove alternating rows (every other row) safely from a dataset in Excel.

How to Delete Every Other Row in an Excel Worksheet
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 you start

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.

Solution 1Recommended

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.

1
Insert a helper column

Add a new, empty column next to the dataset you want to clean up, and label the header as 'Helper'.

2
Enter the formula

In the first cell of the Helper column, type =ISODD(ROW()) to flag odd-numbered rows, or =ISEVEN(ROW()) to flag even-numbered rows.

3
Apply formula to all 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.

4
Filter the results

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.

5
Delete visible rows

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.

Formula Accuracy: The ROW() function dynamicly checks the current row number. If you are dealing with a specific range, you can also use =ISODD(ROW(A1:A1000)).
Efficient Data Management

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the Excel workbook containing your dataset.
  2. 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. 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'.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) and complex formulas.Built-in advanced AutoFilter functionality to easily sort and manage helper columns.Free to download and use, offering a familiar interface with zero learning curve.Supports advanced developer tools and macros for desktop automation.
microsoft office alternative - wps office

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.