How to Undo Remove Duplicates in Excel: 3 Methods

Method 1 – Using Keyboard Shortcut to Undo Remove Duplicates in Excel

Step 1:

  • Go through the data set for this procedure.
  • Check if any duplicates are present in the data set.
  • See two duplicate values in our data set, which are $2500.00 and $1950.00.

Handy Ways to Undo Remove Duplicates in Excel

Step 2:

  • Select the data range from cell C4:C12 for the removal of duplicates.

Handy Ways to Undo Remove Duplicates in Excel

Step 3:

  • Go to the Data tab of the ribbon.
  • From the Data Tools group, select the Remove Duplicates command.

Handy Ways to Undo Remove Duplicates in Excel

Step 4:

  • You will see the Remove Duplicates dialogue box.
  • Under the Column heading, only check the Monthly Salary box.
  • Press OK.

Handy Ways to Undo Remove Duplicates in Excel

Step 5:

  • See no duplicates in the data set after performing the previous steps.

Handy Ways to Undo Remove Duplicates in Excel

Step 6:

  • In the sixth step, we will undo the removal of these duplicates.
  • Press Ctrl+Z on your keyboard right after the removal.
  • See the duplicate values have been restored in their places.

Handy Ways to Undo Remove Duplicates in Excel


Method 2 – Utilizing Quick Access Toolbar to Undo Remove Duplicates

Step 1:

  • Select the data set with duplicate values in it.

Handy Ways to Undo Remove Duplicates in Excel

Step 2:

  • Remove those duplicate values by following the previous method.

Handy Ways to Undo Remove Duplicates in Excel

Step 3:

  • Undo this removal process.
  • Go to the Quick Access Toolbar, which is above the primary ribbon of the worksheet.

Handy Ways to Undo Remove Duplicates in Excel

Step 4:

  • Select the Undo arrow icon from the toolbar.
  • From the dropdown, select the Remove Duplicates command.

Handy Ways to Undo Remove Duplicates in Excel

Step 5:

  • By performing this action, you will undo the process of removing duplicates from the data set.

Handy Ways to Undo Remove Duplicates in Excel


Method 3 – Applying VBA to Undo Remove Duplicates in Excel

Step 1:

  • Take the data set that has duplicate values.

Handy Ways to Undo Remove Duplicates in Excel

Step 2:

  • Remove all the duplicates from the data set.

Sample Data Set

Step 3:

  • Go to the Developer tab of the ribbon.
  • Choose the Visual Basic command from the Code group.

Sample Data Set

Step 4:

  • You will see the VBA window.
  • From the Insert tab choose Module.

Sample Data Set

Step 5:

  • In the fifth step, copy the following code into the module.
'Set the function name
Sub Undo_Remove_Duplicates_in_Excel()
'Giving command to undo the removal
Application.Undo
End Sub

Sample Data Set

Step 6:

  • Save the code and press the play button or F5 to run it.

Sample Data Set

Step 7:

  • After running the code, all the removed duplicates will be restored in the data set.

Sample Data Set


Download Practice Workbook

You can download the free Excel workbook here and practice on your own.


Related Articles


<< Go Back to Remove Duplicates in Excel | Duplicates in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo