Microsoft Excel Logo

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.

Note: 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.

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

Select cells in an Excel spreadsheet.

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

Click the "Home" tab in Excel.

Advertisement

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

Click the "Clear" option in the "Home" tab.

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

Select "Clear Formats" from the "Clear" menu.

And Excel will remove all formatting from your selected cells.

Formatting removed for the selected cells in an Excel spreadsheet.

You’re all set.

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

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.

Select all cells in an Excel spreadsheet.

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

Click the "Home" tab in Excel.

Advertisement

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

Select "Clear" in the "Home" tab.

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

Choose "Clear Formats" from the "Clear" menu.

And all your formatting is gone from your current worksheet.

All formatting removed from an Excel 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

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.