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.

How to clear formatting in Excel? Select all the cells you need (Press Ctrl + A to select all the cells). On the Home tab, in the Editing group, click the arrow next to the Clear button, and then do ...

Formatting cells that aren't used can grow your workbook's file size. See how to reset the last cell on an Excel File to remove formatting.

Excel is known for automatically formatting certain entries, which is often useful but sometimes annoying. This automatic function can now be deactivated on an individual level. We'll show you how.