To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Choose your desired color format for emphasizing duplicates and confirm with OK. There are several different methods to handle the duplicates, but using Excel's built-in tool is the easiest.