Document Editing Problems

Delete Even-Numbered Rows in Excel Using a Helper Column

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user needs to delete even-numbered worksheet rows from a large Excel dataset.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A large dataset needs to be reduced by removing rows based on their original worksheet row numbers.
Observed behavior
A helper column can identify even-numbered rows so they can be grouped and deleted efficiently.
Before you start

Identify the full dataset, including any header row, and check whether other data shares the worksheet rows you plan to delete. If you need to restore the original order after sorting, add a second helper column with =ROW() and convert its results to values before sorting.

Solution 1Recommended

Mark and delete even-numbered rows in Excel

Use a helper column to group rows that were even-numbered before sorting, then delete them together.

1
Add a helper column

Insert a blank column next to the dataset and give it a header such as Even Row.

2
Mark the rows

In the first data cell of the helper column, enter =ISEVEN(ROW()) and use the fill handle to copy it down through the dataset. TRUE marks an even-numbered worksheet row.

3
Freeze the results

Select the helper results and copy them. Use Home > Paste > Values to replace the formulas with their current TRUE or FALSE values before sorting.

4
Group and delete

Select the entire dataset, including its headers, and use Data > Sort to sort by the Even Row column. Select the worksheet row headers for the contiguous TRUE group, right-click, and choose Delete.

5
Review the result

Check the remaining data and any formulas or linked data before saving. If you created an original-row-number helper, use Data > Sort to restore the remaining records to their original order, then remove the helper columns.

Deleting affects entire worksheet rows: Deleting selected row headers also removes other cells on those rows, including data outside the sorted dataset. Check for such data before deleting.
WPS Spreadsheet

Delete even-numbered rows with WPS Spreadsheet

Use a helper column and sorting in WPS Spreadsheet to group and remove originally even-numbered rows from a worksheet.

  1. 1. Open the workbook: Open your Excel workbook in WPS Spreadsheet and select the worksheet containing the dataset.
  2. 2. Mark even rows: Add a helper column, enter =ISEVEN(ROW()) in its first data cell, and drag the fill handle down to the last record.
  3. 3. Freeze and sort: Copy the helper results and use Paste Special > Values to fix the TRUE and FALSE markers. Select the full dataset and use Data > Sort to group it by the helper column.
  4. 4. Delete and review: Select the row headers for the TRUE group, right-click, and choose Delete. Review the remaining data and formulas before saving the workbook.
Identify even-numbered worksheet rows with a formulaGroup marked rows for deletion with sortingOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Does the formula identify even worksheet rows or every second record?

=ISEVEN(ROW()) checks the worksheet row number. If the first record is on row 2, it will be marked TRUE, regardless of its position within the dataset.

Why should I paste the helper formulas as values before sorting?

ROW() reflects a cell's current worksheet position, so its results can change when rows move. Use Paste > Values to preserve the original TRUE and FALSE markers.

Will sorting change the order of the remaining records?

It can. Before sorting, add another helper column with =ROW(), fill it down, and paste the results as values. After deleting the TRUE rows, sort the remaining dataset by that column in ascending order.

What happens to data outside the selected table when I delete rows?

Deleting worksheet rows removes all cells on those rows, including cells outside the table. Check the rest of the worksheet before using the row-header Delete command.