In Excel: select the cells and choose Home ▸ Clear ▸ Clear Formats to remove fonts, fills, borders and number formats while keeping the values and formulas.
Select the messy range.
Open Home ▸ Clear ▸ Clear Formats.
Check that values and formulas remain.
Reapply essential number formats such as dates, percentages or currency.
What this does
Clear Formats removes presentation from selected cells without deleting their contents. It resets colors, fonts, borders, alignment and number formats, but values and formulas remain. It is different from Clear All, which removes both content and formatting. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “remove format excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workflow that saves repeating the same clicks every week, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
A pasted vendor list arrives with colored fills, mixed fonts and currency formats. Select the range, choose Home ▸ Clear ▸ Clear Formats, then reapply only the date and currency formats you actually need. Clearing formats is a fast cleanup step before analysis, imports and reports where pasted styling makes data hard to read or process. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. If you take one thing from this page on “remove format excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Using Clear All and deleting data.
- Clearing formats from cells where number format carries meaning.
- Forgetting that conditional formatting rules can reapply colors.
- Selecting too large a range and removing report styling outside the target data.
Frequently asked questions
Does Clear Formats delete formulas?
No. It keeps values and formulas.
How is Clear Formats different from Clear All?
Clear All removes contents too; Clear Formats only removes cell formatting.
Why did colors come back?
A conditional formatting rule may still be active.
Other ways people ask this
People reach this page typing “how to remove format in excel” and “how to remove formats in excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “how to remove format in excel”, “how to remove formats in excel” all point at the one operation explained on this page, which is why they all lead here.