Data Import & Export

How to Remove Excel Duplicates Only from Selected Rows

Aamir Naveed Akram Sep 28, 2026 869 views

Question details

The user wants to delete duplicate values from a specific highlighted range of rows without the operation automatically applying to the entire column.

How to Remove Excel Duplicates Only from Selected Rows

Product: Excel
Device & OS: not provided
Scenario: Cleaning up a specific subset of data while preserving the rest of the worksheet and adjacent rows.
Observed behavior: By default or due to an incorrect prompt selection, the program deletes every duplicate in the entire column rather than restricting the action to the highlighted rows.

Before you start

Carefully click and drag to highlight only the specific rows you want to clean before opening the duplicate removal tool to ensure adjacent data remains untouched.

Solution 1Recommended

Remove Duplicates Using the 'Continue with Current Selection' Option

Restrict the duplicate removal process strictly to the rows you have highlighted by preventing Excel from automatically expanding the selection range.

When Excel detects adjacent data next to your highlighted rows, it assumes you might have missed selecting the whole dataset. It will prompt you to expand the selection. Choosing the correct option here is the key to limiting the deletion to your specific rows.

Select the Target Rows

Use your mouse to click and drag over the specific rows or range of cells where you want to identify and remove duplicates.

Open the Remove Duplicates Tool

Navigate to the 'Data' tab on the top ribbon and click on the 'Remove Duplicates' button in the Data Tools group.

Choose the Correct Selection Option

A warning dialog box will appear. Select the radio button for 'Continue with the current selection' and click the 'Remove Duplicates...' button. Do not choose 'Expand the selection'.

Confirm and Execute

Verify the columns listed in the final prompt. Click 'OK' to delete the duplicates only from your highlighted rows.

Remove Duplicates Using the 'Continue with Current Selection' Option

Tip: Once completed, Excel will display a pop-up summarizing how many duplicate values were found and removed within your specific selection, leaving the unselected rows intact.

Efficient Data Cleaning

Easily Remove Duplicates in WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive 'Remove Duplicates' tool that perfectly respects your selected data ranges, ensuring you only clean the rows you intend to.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your target workbook.
2. Highlight the target rows: Select only the specific range of rows from which you want to delete duplicates.
3. Access Remove Duplicates: Go to the 'Data' tab and click on the 'HighLight Duplicates' drop-down, then select 'Remove Duplicates'.
4. Select Current Range: Choose to operate only on the current selection in the prompt dialog to ensure adjacent rows are unaffected.

Selectively remove duplicates in specific rows or columns with ease.Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Clear visual prompts prevent accidental data deletion outside your selection.Free, lightweight, and fast data processing.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel delete duplicates from the whole column when I only selected a few rows?

This happens if you choose 'Expand the selection' when prompted. Excel assumes your highlighted area is part of a larger table. To restrict the action to your selected rows, you must choose 'Continue with the current selection'.

Can I use conditional formatting to just highlight duplicates in selected rows instead of deleting them?

Yes. Select your specific rows, go to the Home tab, click Conditional Formatting > Highlight Cells Rules > Duplicate Values. This will color-code the duplicates in your selection without removing any data.

Does removing duplicates shift my remaining data up?

Yes, when duplicate rows are removed, the cells directly below them in the selected range will shift up to fill the gaps left by the deleted rows.

Excel & Data Problems