How to clear formatting in Excel [multiple options + keyboard shortcut]

September 22, 2021

Adding colors and number formatting can improve the readability of your Excel reports, but sometimes you will want to remove all the formatting and start over. This is why it is essential to learn how to clear formatting in Excel as quickly as possible (we also want to be efficient, right?).

How to clear all formatting in Excel

The most common way to remove all formatting in Excel is via the Clear Formatting option. To achieve this, simply follow these steps:

  1. Select a cell or range of cells from which you want to clear formatting.
  2. Navigate to the Home tab and locate the Editing group.
  3. Click on the Clear button to open the Clear menu, and select Clear Formats.
Clear Formatting menu

How to clear formatting using Format Painter

An alternative option is to remove formatting using Format Painter:

  1. Select a blank cell that contains no formatting.
  2. Navigate to the Home tab.
  3. From the Clipboard group, select Format Painter. You will see a dotted line around the cell once the Format Painter option is activated.
  4. Select all the cells for which you want to clear formatting. This will revert them to the default Excel format.
Removing formatting using Format Painter

Keyboard shortcut to Clear Formatting

Clearing formatting using a keyboard shortcut is very fast. All you need to do is:

  1. Select the cells from which you want to remove the formatting.
  2. Press ATL + H + E + F.

Quick Tip: You need to press the keys in successive order, not all at once.

Remove all Cell Formatting from the entire worksheet

Removing cell formatting from the entire worksheet is just as easy.

  1. Press CTRL + A to select the entire cells from your worksheet. Alternatively, you can click on the green triangle from the upper left part of your workshhet (above row 1 and to the left of column A).
  2. Navigate to the Home tab > Editing group.
  3. Open the Clear menu and select Clear Formats.

Quick Tip: If you have manually applied formatting only to some part of the cell contents, then you will have to change the color of the cell back to black manually. Using either Clear Formats or Format Painter will not remove such formatting. In the screenshot below, you can see that the word 'increased' has been formatted with green.

Neither Clear Formats nor Format Painter can remove formatting that is applied only to a part of the cell contents.

How to clear Conditional Formatting in Excel

Conditional Formatting is a very powerful tool and can be used to achieve so many things. In fact, I've written a comprehensive article on How to find duplicates in Excel using Conditional Formatting.

However, if you apply too much Conditional Formatting, this will significantly slow down your Excel file. If this is the case, then it's really important to know how to clear Conditional Formatting in Excel using just a few easy steps:

  1. Select the cells from which you want to remove the Conditional Formatting.
  2. Navigate to the Home tab and locate the Styles group.
  3. Click on the Conditional Formatting button to open the menu.
  4. Click on the Clear Rules button and select the Clear Rules from Selected Sheet.

Alternatively, you can use the keyboard shortcut ALT + H + L + C + S to achieve the same result.

Clear Conditional Formatting from Selected Cells

Quick Tip: You can also remove the Conditional Formatting from the entire worksheet by selecting Clear Rules from Entire Sheet.

If you still don't understand how to clear formatting in Excel after reading this article, please leave a comment, and I'll help you out. I reply to every single comment.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Essential Functions

Excel Topics

Excel courses

I have compiled a list of the best Excel online courses. It covers basic and advanced topics, VBA, and Power BI.
View courses
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022