How to Remove Duplicate Numbers and Entire Rows in WPS Office Spreadsheets
Question details
The user needs to remove repeated numbers from one column while deleting the corresponding entire duplicate rows, keeping only one complete record per unique number.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A worksheet contains duplicate identifying numbers in a column, and the rows associated with later duplicates need to be removed so each unique number has a single complete record.
- Observed behavior
- Duplicate numbers appear multiple times in the column, causing multiple rows for the same record. The user wants the spreadsheet to keep the first occurrence and remove subsequent matching rows.
Open the worksheet in WPS Office Spreadsheets and click anywhere inside the data range before opening Remove Duplicates. Decide which column contains the duplicate identifiers, because WPS will use only the selected columns to determine whether a row is a duplicate.
Use Remove Duplicates to Delete Duplicate Numbers and Their Rows
Use this method when you want WPS Spreadsheets to retain the first entire row for each unique number and delete all later duplicate rows.
WPS Office Spreadsheets includes a Remove Duplicates command in the Data tab. When only the column containing duplicate numbers is checked, WPS treats rows as duplicates based on that column and keeps the first matching row unchanged.
Open your WPS Office Spreadsheets workbook and click any cell inside the data range that contains the duplicate numbers.
Go to the Data tab, find the Data Tools group, and click Remove Duplicates.
In the Remove Duplicates dialog, verify the column with the repeated numbers is checked. If other columns are checked, uncheck them so the removal is based only on the duplicate number column.
Click OK. WPS Spreadsheets keeps the first occurrence of each number and removes the other matching rows, including their associated information.
Remove Duplicate Numbers and Entire Rows in WPS Office Spreadsheets
WPS Office Spreadsheets provides a free, built-in Remove Duplicates tool that deletes repeated numbers and their entire rows while keeping the first complete record. You can perform the cleanup without switching to Microsoft Excel, and your .xlsx and .xls files remain fully compatible.
- 1. Open your workbook in WPS Office Spreadsheets: Launch WPS Office and open the .xlsx or .xls file that contains the duplicate rows.
- 2. Click inside the data range: Click any cell in the table or range where the duplicate numbers are located.
- 3. Run Remove Duplicates: Go to Data > Data Tools > Remove Duplicates.
- 4. Select only the duplicate number column: Check the column that holds the repeated numbers and uncheck the other columns, then click OK.
- 5. Confirm the result: Review the remaining rows; WPS keeps the first occurrence and removes the later duplicate rows.
Frequently Asked Questions
Will Remove Duplicates delete the entire row or only the duplicate number cells?
It deletes the entire row when the row is identified as a duplicate based on the checked column. The duplicate number cells and all other information in that row are removed together.
How do I remove duplicates based on more than one column?
In the Remove Duplicates dialog, keep multiple columns checked. WPS Spreadsheets will consider a row a duplicate only when all selected columns match another row.
Does WPS Office Remove Duplicates keep the first or last occurrence?
WPS Office Spreadsheets keeps the first occurrence and removes the subsequent duplicate rows. If you need a different record to be kept, sort the data before running Remove Duplicates.
Can I undo a Remove Duplicates action?
You can press Ctrl+Z immediately after the action to undo it. After the file is closed, the removal may be permanent, so review the selected column before clicking OK.
