Click the Paste Special option from the list.In this example the range A3:I12 is selected. Select the range from which formatting needs to be removed.We have selected and copied cell H3 which has the default formatting. Select the range of cells that you want to copy.

Let’s see how we can use the Paste option for clearing format.įollow these steps to restore the formatted cell to the default cell format with the help of Paste Special Format. This can be achieved using Paste Special special option. While pasting copied data you can limit the command to just give you the plain text, format, formula, condition, etc. When copying, the command will copy data along with its formats. 📝 Note: The light gray lines around each cell will remain, but if needed you can hide these worksheet gridlines too for a completely cleared look! Clear Formatting by Paste Format OnlyĬopy and paste are the most common commands, and it is used to move text or data in an instant. Hold the control key and then press the backward-slash key and your formatting will be removed. Select a range from which to clear formatting.To clear the format by using a shortcut key, follow these steps. We can also use a keyboard shortcut to clear formatting in Google Sheets. Clear Formatting with a Keyboard Shortcut That’s it! Your selected range will have all the formatting removed so you might want to note down any special color codes for future use. Click the Clear formatting option at the bottom of the menu.Select the cell or a range from which you want to remove the formatting.We can restore a selected range to the default formatting with the help of the Format menu.įollow these steps to remove formatting in Google Sheets. The Format menu gives us the ability to change the formatting of the selected range and it also allows users to remove any applied formatting. Get your copy of the example workbook and follow along! Clear Formatting from the Format Menu

Clear formatting definition