How to Clear Formatting from a Cell in Google Sheets

When you type data into a cell in Google Sheets, that data uses the default formatting for the sheet, assuming that the cell doesn’t have some pre-existing formatting applied to it from old data. But not all of the data that you put into your spreadsheet is being typed, and it’s entirely possible that you will copy and paste data from another document that has its own formatting.

Doing this several times can result in a spreadsheet with a lot of differently formatted cells, which can make it difficult to read. Fortunately Google Sheets has a tool that will let you clear formatting from a cell and restore it to the default sheet formatting.

 

How to Clear Formatting in Google Sheets

The steps in this article assume that you have an existing Google Sheets spreadsheet that contains a cell with formatting that you wish to remove. Completing these steps will remove all of the formatting that is applied to the selected cell(s). If you find that it has removed something that you wanted, then you can either undo the action and manually remove the formatting that you don’t want, or you can reapply the formatting once it has been removed.

Step 1: Sign into your Google Drive at https://drive.google.com/drive/my-drive and open the Google Sheets file containing the formatting that you want to remove.

 

Step 2: Select the cell(s) from which you would like to clear the formatting.

select the cell

 

 

Step 3: Click the Format tab at the top of the window.

how to remove cell formatting in google sheets

 

 

Step 4: Select the Clear formatting option at the bottom of the menu.

how to clear formatting in google sheets

 

 

Note that you can also clear the formatting from a selection by pressing Ctrl + \ on your keyboard.

 

Is there a worksheet in your Sheets file that you had previously hidden, either on purpose or by accident? Find out how to unhide a worksheet in Google Sheets so that you can edit or view the data that it contains.