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
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 use it.
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!
Other Google Sheets tutorials you may like:
- Conditional Formatting Based on Another Cell Value in Google Sheets
- The Ultimate Guide to Using Conditional Formatting in Google Sheets
- How to Highlight Duplicates In Google Sheets
- How to Copy a Sheet from One Google Sheets to Another
- How to Show Formulas Instead of Values in Google Sheets
- How To Format Phone Numbers In Google Sheets?