Clear Cell Formatting

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)

comments powered by HyperComments
READ  Remove Duplicates from a Selection of Data