Interactive Tutorial
Format Painter in Google Sheets
Copy and Apply Formatting Quickly Using the Format Painter Tool in Google Sheets
-
Learn by Doing
-
LMS Ready
-
Earn Certificates
Try this Course with a Free Trial
If you have spent some time formatting cells to make them look great, you can easily copy just the formatting of a cell.
Paste Copied Formatting
- Select a cell or cell range with formatting that you want to copy.
- Click the Paint format button on the toolbar.
- Select a cell or cell range you want to paste the formatting onto.
The formatting is applied to the selected cell or range.