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.

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.

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.

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.