SUMMARY: A few mouse clicks or a keyboard shortcut are all it take to clear formatting from a cell or group of cells.
Have you ever had a cell or group of cells in a Microsoft Excel 2010 worksheet that contain a lot of formatting applied, such as combinations of different fonts, colors, underline styles, effects, etc.? If you need to remove formatting from these cells try the following:
1. Select the cell or group of cells from where you want to remove formatting, or press Ctrl +A to affect the entire worksheet.
2. Click the “Home” tab in the Ribbon.
3. In the “Editing” section, click the “Clear” button. If you do not see a “Clear” button, click the eraser.
4. From the pull-down menu that follows, click the “Clear Formats” link.
You can also use the following shortcut: Alt, H, E, F (without the commas)