Select the range of cells you want to check
Go to the Home tab
Click Conditional Formatting
Choose Highlight Cells Rules
Select Duplicate Values
Pick a formatting style
Click OK
Use the Remove Duplicates feature from the Data tab to delete duplicate rows
Use the COUNTIF formula to identify repeated values
Use Filter to display only duplicate entries
Sort the data to group duplicates together
Use PivotTables to summarize repeated values