How to Clear Formatting and Remove Cell Styles in Microsoft Excel

When you inherit a spreadsheet from a colleague or copy and paste data from a website, the formatting is usually chaotic. You might have bright yellow background colors, bold red text, mismatched fonts, and thick black borders scattered randomly across your data. Attempting to manually undo each of these styles one by one is incredibly tedious. Instead of fighting with the font menus, you can use a hidden Microsoft Excel feature to instantly strip away all formatting, leaving you with perfectly clean, plain text.

How to Clear All Formatting from a Cell

The “Clear Formats” tool is the fastest way to reset your data without actually deleting the numbers or text inside the cells.

1. Open your spreadsheet in Microsoft Excel.
2. Using your mouse, highlight the specific cell, row, or massive data range that contains the chaotic formatting. (To select the entire worksheet, click the small triangle in the absolute top-left corner where the column letters and row numbers intersect).
3. Click on the Home tab in the main ribbon menu at the top of the screen.
4. Look to the far right side of the ribbon for the “Editing” group.
5. Click the Clear button (it is usually represented by a pink eraser icon).
6. A drop-down menu will appear. Click on Clear Formats.

Every single style—including background fill colors, font sizes, bold/italic styles, custom number formats (like currency symbols), and cell borders—will be instantly wiped away. Your data will remain completely intact, but it will revert to Excel’s default style (usually 11pt Calibri font, black text, no background).

The Difference Between Clear Formats and Clear All

When you click the pink eraser icon, you will notice several different options. It is crucial to understand the difference so you do not accidentally delete your work.

• Clear Formats: Strips away the visual styling (colors, fonts, borders) but leaves the text, numbers, and underlying mathematical formulas completely untouched.
• Clear Contents: Acts exactly like pressing the Delete key on your keyboard. It deletes the text and numbers inside the cell, but keeps the visual styling. (If the cell was painted yellow, it will remain an empty yellow box).
• Clear All: A total nuclear option. It deletes the data, deletes the formulas, and wipes away all formatting, returning the cell to a completely blank, factory-reset state.

How to Strip Formatting While Pasting

If you are copying a table from a Wikipedia article, you can prevent the chaotic HTML formatting from ever entering your spreadsheet in the first place.

1. Copy the data from the website (Ctrl + C).
2. Right-click the destination cell in Excel.
3. Instead of clicking the standard Paste button, look under the “Paste Options” section for an icon showing a clipboard with the letter A on it. This is the Match Destination Formatting button.
4. Click it, and the data will be pasted as pure, unformatted text.