Formatting data and making it look good and more readable is something we often do when working with Google Sheets.
And Google Sheets has a tool that makes copy-pasting of formatting really easy.
It’s the Format Painter tool (called the Paint Format in Google Sheets).
Once you have applied the formatting to a cell or range of cells, you can use the format painter to copy it to another cell/range in the same worksheet or other worksheets in the same document.
In this tutorial, I will show you how to use the format painter to copy and paste the formatting in Google Sheets.
Format Painter in Google Sheets
Format Painter is one of those functionalities in Google Sheets that’s available only in the toolbar (and not in the menu drop-down options).
You can find it on the left in the toolbar (see the image below).
This format painter tool works as a toggle.
When you click on it once, it gets activated and when you click it twice, it gets deactivated.
How to Use Format Painter in Google Sheets
Wondering how to copy formatting in Google Sheets? Follow these quick and easy directions to easily copy formatting in just a few clicks.
Suppose you have a dataset as shown below where I have formatting in column A and no formatting in column B.
Below are the steps to use the format painter in Google Sheets:
- Select the cells that have the formatting that you want to copy
- Click on the Paint Format icon in the toolbar. This is activated the format painter (you will see that the icon would become green)
- Select the cells on which you want to copy the formatting
The above steps would easily copy-paste the formatting from column A to column B.
Note that once you activate the format painter, you can only use it once. After that, you need to activate it again to copy formatting again.
Also, when you select a cell and click on the paint format icon in the toolbar, it copies the formatting. Now, when you select the same size target cell, the exact formatting is copied. But when you select a larger range, the formatting repeats.
And one more thing, you can also use format painter to copy conditional formatting rules as well. In case you have used formulas in the conditional formula when you copy-paste the conditional formatting, the formula references would adjust accordingly.
I hope you found this tutorial useful!
Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.