In this tutorial, you will learn how to clear formatting in Google Sheets.
How To Clear Formatting In Google Sheets
Quick Navigation
Formatting can be an effective way to make your data more presentable and easier to navigate. However, you may later want to clear the formatting from your cells.
For example, if you’ve copied data from another sheet, you might want to remove any prior formatting. You also may just want to revert a cell back to its default styling.
In this guide, we will show you how to clear formatting from your cells in Google Sheets.
How to Revert Cells to Default Styling in Google Sheets.
Here’s how to revert cells to default styling in Google Sheets.
Step 1
First, select the range of cells you want to revert to default styling.
In this example, we want to clear the formatting in the range A1:E13.
Step 2
In the Format menu, click on the Clear formatting option. Alternatively, you can use the Ctrl+\ keyboard shortcut to clear formatting.
After selecting this option, the selected range should now return to the default styling.
Step 3
We can also use the Paste Special feature to clear formatting.
First, select the range that you want to clear formatting for. Type the keyboard shortcut Ctrl+C to copy the range to your clipboard.
Step 4
Select an empty range in your sheet and type Ctrl+Shift+V to paste just the values of the copied range. Alternatively, you can select Paste special > Values from the right-click context menu.
Step 5
The pasted data should now be clear of any prior formatting.
Step 6
We can also use the Paint format feature to clear formatting in Google Sheets.
First, select any cell in your sheet with default styling.
In the example above, we selected the empty cell G2.
Step 7
Next, click on the Paint Format icon in the toolbar, as seen below.
Step 8
Select the entire range you want to clear formatting for.
Release the cursor to apply the defaul formatting copied from the empty cell earlier.
Summary
This guide should be everything you need to clear formatting in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.