Quickly Clear all Formatting in Excel

This includes removing any and all types of formatting but leaving all data intact inside the cell.  You can do this to one or many cells and it's quite simple.

Steps to Quickly Remove Formatting in Excel

1. Select the data:
   
2. Go to the Home tab and on the right side click the white eraser and select the Clear Formats option(you can also use the keyboard shortcut Alt + E + A + F and this shortcut also works in Excel 2003):
   
3. Now, your data is format-free:
   

This is sooooo much faster than removing each formatting element individually and, oddly enough, very few people know about this feature and, therefore, many waste hours each year individually removing formatting elements from cells in Excel.

Keyboard Shortcut to Remove All Formatting from Cells in Excel

Alt + E + A + F

This will work in every version of Excel.