Clear / Remove All Formatting in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on July 15, 2023

This tutorial demonstrates how to clear and remove all formatting in Excel and Google Sheets.

clear format excel 2

Clear Formats

In Excel, you can remove all formatting from a cell or range of cells with one command. This resets all formatting; any bolding, colors, number formats, etc. are cleared. Say you have a dataset formatted as shown in the picture below.

clear format initial data 2

As you can see, there’s a variety of formatting here. The font color for the headings is white, cell D2 is center aligned, every other row is light blue, Column D values are formatted as dates, etc.

To remove all these formats and have plain data with default font size and a general format, follow these steps:

  1. Select the range (B2:D9).
  2. Then in the Ribbon, go to the Home tab.
  3. Choose Clear from the Editing tab.
  4. Click Clear Formats.

clear all formatting 2

As a result, all data formats are cleared from range B2:D9. All cells are left bottom aligned, there is no background color, and all data have a general format.

clear format excel 2

Tip: You can clear cells completely in a similar way.

Clear Formats in Google Sheets

In the same way as in Excel, formats can be cleared in Google Sheets with a single command. We’ll use the same example as above.

  1. So to clear formats in Google Sheets, first select the range.
  2. Then in the Ribbon, go to Format.
  3. Choose Clear Formatting. (Or use the CTRL + / shortcut.)

clear format google sheets 2

As a result, all data formats are cleared in the range B2:D9.

removed formats google sheets 2

AI Formula Generator

Try for Free

See all How-To Articles