Question
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 highlighted with a different colour.
They are deleted from the worksheet.
They are merged into a single cell.
They are replaced with blank cells.
They are highlighted with a different colour.
They are deleted from the worksheet.
They are merged into a single cell.
Answers
GPT-4o mini
When using the "Delete Duplicates" function in Excel, the duplicate values in the selected range **are deleted from the worksheet**. Only the first occurrence of each unique value is retained.