Delete Even-Numbered Rows in Excel Using a Helper Column
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.
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.
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.
Insert a blank column next to the dataset and give it a header such as Even Row.
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.
Select the helper results and copy them. Use Home > Paste > Values to replace the formulas with their current TRUE or FALSE values before sorting.
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.
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.
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. Open the workbook: Open your Excel workbook in WPS Spreadsheet and select the worksheet containing the dataset.
- 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. 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. 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.

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.




