How to Delete Formatting in Excel Without Losing Data

How-to basics · Updated November 20, 2026

To delete formatting in Excel while keeping the cell contents, select the cells, then choose Home > Clear > Clear Formats. This removes applied formatting—such as fonts, fills, borders, alignment, and number formats—without deleting values or formulas. Before clearing a large area, confirm that you selected only the cells you mean to change; use a copy of the workbook if you need to preserve its current appearance.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same general ribbon command is available in current Excel for Mac and Excel for the web, though the ribbon layout can differ slightly.
  • The cells, rows, columns, or worksheet area whose formatting you want to remove. If the workbook is important, save a copy first so you can restore the original appearance if needed.
  • Permission to edit the selected cells. A protected worksheet may prevent formatting changes until it is unprotected by someone with the password or appropriate access.

Step-by-Step

  1. Open the workbook and identify the target area. Find the cells that look different from the rest of the worksheet, and decide whether you want to reset one cell, a range, a whole row or column, or the entire sheet. If you only want to remove one kind of formatting—for example, a fill color—consider changing just that property instead of clearing every format.
  2. Select the cells carefully. Click and drag over a rectangular range, or click the first cell, hold Shift, and click the last cell to select the range between them. To select separate areas, hold Ctrl while selecting each area on Windows; on Mac, hold Command. To select a whole column or row, click its letter or number header. To select the entire worksheet, click the small triangle at the intersection of the row and column headers. This is safer than relying on Ctrl+A, which can select only the current data region the first time it is pressed.
  3. Open the Clear menu. On the Home tab, find the Editing group at the right side of the ribbon. Click Clear to open its menu. If the Excel window is narrow, the Editing commands may be condensed or displayed in a different arrangement; maximize the window or look for the Clear command within the Home tab.
  4. Choose Clear Formats. Click Clear Formats, not Clear All or Clear Contents. Excel removes the selected cells’ direct formatting while leaving their values and formulas in place. The cells may immediately look plainer, and dates, percentages, or currency values may display differently because their number formats have been reset.
  5. Check the result and the underlying data. Click a few changed cells and inspect the formula bar. A formula should still appear there if the cell contained one, and a typed value should remain. Check a date or currency cell too: the stored value can be intact even if it now appears as a number or without a currency symbol. If the result is not what you intended, press Ctrl+Z on Windows or Command+Z on Mac immediately to undo the change.
  6. Repeat for other areas only if needed. Clear Formats applies to the selection, so formatting elsewhere on the worksheet is not affected. Select another range and repeat the command if the unwanted appearance occurs in several separate places. For large, scattered areas, take extra care with multi-selection and verify the highlighted cells before clearing.
  7. Save the workbook when you are satisfied. Use Ctrl+S on Windows or Command+S on Mac. If you are working in Excel for the web, changes are normally saved automatically, but wait for the saved status before closing the browser tab. Keep the backup if the original formatting may be needed later.
  8. Use the equivalent command on Mac or the web. In current Excel for Mac, select the cells and use Home > Clear > Clear Formats when that command is shown on the ribbon; the ribbon may be more compact than on Windows. In Excel for the web, select the cells, open the Home tab, and look for Clear and then Clear Formats. If the command is not visible, expand the ribbon or use the command search box to find Clear Formats. The Windows Alt key sequence is not a Mac shortcut.

Common Mistakes

Choosing Clear All instead of Clear Formats. Clear All can remove cell contents and other cell information as well as formatting. If your goal is to keep data, use the command whose name specifically says Clear Formats. Pause to read the menu item before clicking, especially when clearing a large selection.

Clearing formats when you only wanted to change the color. Clear Formats also resets number formats, fonts, borders, and alignment. A date can stop displaying as a date, and a percentage may appear as a decimal. If you want to preserve other styling, use the relevant formatting control instead: for example, choose a new fill color from the Fill Color menu or select a number format from the Number Format list on Home.

Selecting the wrong range. A missed row, an extra column, or the whole worksheet selected by mistake can make the result look worse. Look at the selection outline and shaded cells before using Clear Formats. If you notice the mistake right away, undo before making further edits.

Expecting Clear Formats to remove every visual effect. Conditional formatting rules, table styles, and row or column dimensions can be controlled separately from ordinary cell formatting. A cell may therefore still look colored, or a column may remain wide, after you clear formats. Identify the source of the appearance before repeating the command.

Tips

  • Understand what remains. Clear Formats is intended to reset appearance, not erase the cell’s value or formula. It also does not automatically resize columns or rows. Formulas, text, and numbers should remain, while font, fill, borders, alignment, and number presentation are reset.
  • Reset one property when that is enough. To remove a border but keep the font and number display, use the Borders menu and choose No Border. To remove a fill, use Fill Color and choose No Fill. To restore a standard number display, select the cells and choose General from the Number Format list. These targeted edits avoid changing unrelated styling.
  • Be aware of dates and percentages. Excel stores dates and times as numbers and percentages as numeric values. Their formatting controls how those values appear. After clearing formats, a date may show as a serial number and 25% may show as 0.25; that does not by itself mean the underlying value was deleted. Apply the appropriate date or percentage format again if you want the familiar display.
  • Check whether a table style is responsible. If the cells are inside an Excel table, banded rows and header styling may come from the table’s design rather than ordinary cell formatting. Select a table cell and open the Table Design tab to review the Table Styles options. Clearing cell formats may not remove the table’s style; changing the table style or converting the table to a range is a separate decision.
  • Keep a clean example nearby. If you want some cells to match a known-good area, copying that area and using Paste Special > Formats can be a useful alternative to clearing everything. Check the result, since copying formats can also copy number displays, borders, and other styling you did not intend to change.

Troubleshooting

The cells still look colored after Clear Formats. First check whether conditional formatting is applying the color. Select one of the affected cells and open Home > Conditional Formatting > Manage Rules to inspect rules that apply to the current selection or worksheet. If you intend to remove a rule, use Home > Conditional Formatting > Clear Rules and choose whether to clear rules from the selected cells or the entire sheet. This is a separate action, and removing a rule can affect other cells, so review its scope before confirming.

A table still has banded rows or a colored header. The appearance may be coming from the table style. Select a cell in the table, open Table Design, and choose a different style or adjust the table style options. If you convert a table to a range, table features such as structured references and automatic expansion may change, so do not convert it just to remove a color unless that is what you want.

A date, time, currency, or percentage looks wrong afterward. The number format may have been removed, even though the value remains. Select the cells and choose a suitable format on the Home tab, such as Short Date, Currency, or Percentage. If you are unsure whether the value itself changed, inspect the formula bar and compare it with a known value. Avoid retyping the value until you have checked, since typing over it would replace the existing data.

The Clear command is unavailable or has no effect. The worksheet may be protected, the workbook may be in a restricted editing state, or you may not have permission to edit it. Check the Review tab for protection options; if protection is password-controlled, ask the workbook owner rather than trying to bypass it. Also confirm that the intended cells are selected and that the workbook is not read-only.

You cleared the wrong cells. Use Undo immediately: Ctrl+Z on Windows or Command+Z on Mac. Undo may no longer be available after closing the workbook or after certain actions, so save a backup before broad changes. If you have already saved and closed the file, check whether a prior version is available through your storage service or organizational version history.

Frequently Asked Questions

Does Clear Formats delete data or formulas?
No. The command removes formatting from the selected cells, while their contents and formulas remain. Still, check the cells afterward, particularly if you meant to choose Clear Formats but selected Clear All.

How do I remove formatting from an entire worksheet?
Click the select-all triangle above row 1 and left of column A, then choose Home > Clear > Clear Formats. This affects the whole sheet, so use it only when you want every cell’s direct formatting reset. It will not necessarily remove conditional formatting rules or table styles.

Can I remove only conditional formatting?
Yes. Use Home > Conditional Formatting > Clear Rules, then choose the option for the selected cells or the entire sheet. This removes rules rather than ordinary formatting, so it is the right approach when color or emphasis is being applied by a rule.

Why did my date turn into a number?
Excel stores dates as serial numbers and relies on a date number format to display them as calendar dates. Clear Formats can remove that display format while leaving the underlying value intact. Apply a date format again from the Home tab’s Number Format controls.

Is Clear Formats available in Excel for the web?
Yes, current Excel for the web includes a Clear Formats command on the Home tab. Ribbon layout can vary with window size, so expand the ribbon or search for the command if you cannot see it. Some advanced formatting controls may be arranged differently from the Windows desktop app.

Can I undo Clear Formats?
Usually, yes. Press Ctrl+Z on Windows or Command+Z on Mac soon after the change. If you have made several later edits, undoing may also reverse those edits, so consider saving a copy before a large cleanup.

Related

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.