Step-by-Step Guide: Removing Text Styles & Formatting Errors in MS Excel

Quick Links

• How to Clear Formatting for Select Cells in Excel
• Clear Formatting for All Cells in Excel

Microsoft Excel offers plenty of styling options to customize your spreadsheet’s appearance. If you ever need to remove your formatting , however, it’s easy to do so for both select cells and your entire worksheet. We’ll show you how.

Clearing formatting only removes the style of your text; your actual text is retained.

Related: How to Clear Formatting in a Microsoft Word Document

How to Clear Formatting for Select Cells in Excel

Excel offers the option to remove formatting from a single or multiple select cells. This way you can clear a cell’s formatting without affecting any other cells.

To do so, first, open your spreadsheet with Microsoft Excel.

In the spreadsheet, select the cell or cells from which you want to remove formatting.

To clear formatting in a specific row or column, select that row or column instead of individual cells.

While your cells are selected, in Excel’s ribbon at the top , click the “Home” tab.

On the “Home” tab, in the “Editing” section, click the “Clear” option.

From the “Clear” menu, select “Clear Formats.”

And Excel will remove all formatting from your selected cells.

You’re all set.

If hyperlinks in your cells are giving you grief, learn how to remove hyperlinks or disable them entirely in Excel .

Home Use license is dedicated for personal, non-commercial use only.
If Action! is used for commercial gain or to further any commercial purpose,
a Commercial Use license is required. Multi-license (volume discount) is intended for single

company, user or members of the same household. Action! - screen and game recorder</a>

Clear Formatting for All Cells in Excel

You can remove formatting from your entire worksheet at once. To do so, first, launch your spreadsheet with Microsoft Excel.

On the spreadsheet screen, press Ctrl+A (Windows) or Command+A (Mac) to select your entire worksheet.

While your worksheet is selected, in Excel’s ribbon at the top, click the “Home” tab.

vMix 4K - Software based live production. vMix 4K includes everything in vMix HD plus 4K support, PTZ control, External/Fullscreen output, 4 Virtual Outputs, 1 Replay, 4 vMix Call, and 2 Recorders.
This bundle includes Studio 200 for vMix from Virtualsetworks, HTTP Matrix 1.0 automation scheduler, and 4 introductory training videos from the Udemy vMix Basic to Amazing course.

In the “Home” tab, from the “Editing” section, select the “Clear” option.

In the “Clear” menu, click “Clear Formats.”

And all your formatting is gone from your current worksheet.

That’s it.

On a related note, did you know you can use conditional formatting to find duplicate data in Excel?

Related: How to Use Conditional Formatting to Find Duplicate Data in Excel