When using the "Delete Duplicates" function in Excel, what happens to the duplicate values in the selected range?
They are replaced with blank cells.
They are merged into a single cell.
They are deleted from the worksheet.
They are highlighted with a different colour.
1 answer
They are deleted from the worksheet.