Clear Excel Cell Formatting: What Changes and What Stays

To clear formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Clear > Clear Formats. This removes their applied formatting while keeping their values and formulas; the Windows key-tip sequence is Alt, H, E, F.

What clearing cell formatting means

Excel stores a cell’s content separately from many of its appearance settings. Content might be a number, text, a date, or a formula. Formatting controls how that content looks: it can set the font, fill color, borders, alignment, number display, and other visual properties. Clear Formats removes formatting from the selected cells without deleting their contents.

For example, a cell containing the value 0.25 might be formatted as a percentage and display as 25%. Clearing its formatting changes its display back to the General format, so it will usually show 0.25. The stored value has not changed. Similarly, clearing formatting from a cell containing a formula leaves the formula in place, even though its font, color, or number display may change.

This is different from Clear Contents, which removes values or formulas but leaves the formatting in place. It is also different from Clear All, which removes both content and formatting. Choosing the right command matters when a worksheet contains work you need to preserve.

Clear formats step by step

Select the cell or range you want to change. Drag across adjacent cells, or click a cell and use Shift-click to extend the selection.
On the Home tab, find the Editing group and open Clear. In Excel for Microsoft 365 on Windows, the ribbon path is Home > Clear > Clear Formats.
Check the selected cells. Their direct formatting should be removed, while their values and formulas remain.

On Windows, you can use the ribbon key tips instead of clicking: press Alt, then H, E, and F in sequence. This is a sequence of keys, not a combination pressed all at once. The key tips can vary if Excel is using a different display language or customized ribbon.

In Excel for Mac, select the cells and use Home > Clear > Clear Formats if that command is shown in your ribbon. Ribbon layout can differ by Excel version and window size. The Windows Alt-key sequence does not apply on Mac; use the menu command rather than relying on a Windows shortcut.

Other ways to change formatting

Clear Formats is usually the best choice when the goal is to remove the appearance settings from existing cells. Other tools are useful when you want to copy a known format, reset only one feature, or apply a consistent style instead.

Format Painter: Select a cell with the appearance you want, choose Home > Clipboard > Format Painter, then select the cells to receive that formatting. It copies the source cell’s formatting; it does not clear formatting.
Paste Special: Copy a cell, select the destination, then choose Home > Paste > Paste Special > Formats. This applies the copied formatting without replacing the destination’s cell contents.
Individual controls: Use the Font, Alignment, or Number groups on the Home tab to change a specific setting, such as fill color or number format, without clearing everything else.
Cell Styles: Home > Cell Styles lets you apply a named style, such as Normal. Applying a style is not always equivalent to clearing every formatting source, so use Clear Formats when you need a direct reset.

Format Painter and Paste Special are especially helpful when one cell is already formatted correctly and several others need to match it. For example, if a column has inconsistent borders but the font and number formats are intentional, copying a complete format may alter more than you want. In that situation, change only the border setting instead.

What Clear Formats removes—and what it keeps

For ordinary cells, clearing formats removes direct visual settings such as font styling, fills, borders, alignment, and number formatting. That can make bold text plain, remove a colored background, or change a displayed date or percentage back to a General-style display. The exact appearance after clearing depends on the cell’s content and Excel’s default formatting.

The command is designed to leave the cell’s content alone. Values, text, and formulas remain. It does not mean “delete everything associated with this cell”: data validation, comments or notes, and the underlying value are separate from ordinary cell formatting. A hyperlink’s destination is not the same thing as its blue, underlined appearance, so removing formatting should not be treated as a way to delete a link.

Also distinguish cell formatting from worksheet structure. Clearing a cell’s format does not by itself remove rows or columns, change formulas, or resize columns. It is not a substitute for deleting a table, changing a chart, or changing a worksheet’s layout. If the result is still visually styled, another feature may be supplying that appearance.

Conditional formatting and table styles

Conditional formatting applies a visual format when a rule’s conditions are met. Because rules can continue to govern a range, a cell may still look colored or highlighted after you clear its ordinary formatting. For example, a rule that fills values below zero red can keep coloring a negative number even when you remove the cell’s direct fill color.

To remove conditional formatting rules from selected cells, select them and choose Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Choose Clear Rules from Entire Sheet only when you intend to remove those rules throughout the worksheet. Removing the rule is a separate action from clearing direct formatting, and it can affect how other cells in the rule’s range appear.

Excel tables can also have a table style that supplies banded rows, header shading, or other visual effects. Those effects are controlled through the table’s design options, not necessarily by ordinary formatting applied to individual cells. Select a cell in the table and use the Table Design tab to review the Table Styles and Table Style Options, such as Banded Rows. If you want the table to remain a table, adjust its style or options rather than converting it to a range just to remove its appearance.

Clearing formatting from a range or worksheet

For a range, select only the cells that need resetting before using Clear Formats. This is safer than selecting an entire column or worksheet, particularly when other areas contain carefully designed headings, input prompts, or report formatting. If you need to clear several separate areas, select one area at a time or use Ctrl-click on Windows to add nonadjacent cells to the selection.

To select a whole worksheet on Windows, click the Select All button at the intersection of the row numbers and column letters, then use Home > Clear > Clear Formats. This is a broad change: every cell’s direct formatting may be affected, including formatting far below or to the right of the visible data. If a table style or conditional formatting rule is responsible for an appearance, that feature may need separate attention.

Before clearing a large area, consider saving a copy of the workbook. Excel’s Undo command, Ctrl+Z on Windows or Command+Z on Mac, can usually reverse a recent formatting action, but later edits or actions may change what is available to undo. A saved copy gives you a recovery point if you discover that the selection was larger than intended.

Common problems and how to fix them

The color or highlight remains: Check whether conditional formatting or a table style is applying it. Review the relevant rule or table options rather than repeatedly clearing ordinary formats.
A date turns into a number: The date value is likely still present, but its date number format was removed. Apply an appropriate date format from Home > Number, or use the Number Format list to select a date display.
A percentage looks like a decimal: Clearing formats can remove the percentage display. Apply Percentage from the Number group if that is the intended presentation; the underlying value does not need to be re-entered.
Only some cells change: Check the selection outline before using Clear Formats. Merged cells, filtered ranges, or an accidentally limited selection can make the affected area less obvious than expected.
Formatting returns later: A pasted cell, a table style, a conditional formatting rule, or a workbook style may be applying it again. Identify the source before changing more cells.

One frequent misconception is that a displayed number is the same as its stored value. A value shown as $1,250 may still be 1250 after its currency format is cleared. Likewise, a date may be stored as a serial number and merely displayed as a calendar date. If a cleared cell looks wrong, inspect the formula bar and choose a suitable number format before editing the value itself.

Choosing the right clearing method

Use Clear Formats when you want to remove ordinary formatting from selected cells but preserve their contents. Use Clear Contents when you want to remove the values or formulas but keep the cells’ appearance. Use Clear All only when both content and formatting should go. These commands are not interchangeable, so check the labels in the Clear menu before confirming a broad selection.

If just one property is wrong, change only that property. For instance, use the fill-color control to remove an unwanted fill while preserving a currency format and border. If a cell should look like another cell, use Format Painter or Paste Special > Formats. If the style comes from a conditional rule or table, edit that rule or table style. Choosing the source-specific fix helps avoid undoing formatting that is still useful.

Frequently Asked Questions

Will Clear Formats delete my Excel formula?
No. Clear Formats removes formatting, not the formula or its calculated value. Use Clear Contents or edit the cell if you intend to remove the formula.

How do I clear formatting without deleting data?
Select the cells and choose Home > Clear > Clear Formats. Avoid Clear Contents and Clear All if you need to keep the values or formulas.

Why is a cell still colored after I cleared its formatting?
A conditional formatting rule or table style may be supplying the color. Check Home > Conditional Formatting for rules, and check Table Design if the cell belongs to a table.

Can I clear formatting on an entire Excel sheet?
Yes. Click the Select All button at the top-left intersection of the row and column headings, then choose Home > Clear > Clear Formats. Review the selection first because the command affects the whole worksheet’s direct formatting.

Why did my date or percentage change after clearing formats?
Its stored value usually remains unchanged, but Clear Formats can remove the number format that made it display as a date or percentage. Apply the desired date or percentage format again from the Home tab.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.