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)

Like this post? Please share to your friends:
Leave a Reply

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: