Interactive Tutorial

Copy Formatting

How to Copy Formatting in Google Sheets

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Try this course with a Free Trial

Copy Formatting

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

  1. Select a cell or cell range with formatting that you want to copy.
  2. Click the Paint format button on the toolbar.
  3. Select a cell or cell range you want to paste the formatting onto.
    How to paste copied formatting in Google Sheets.

The formatting is applied to the selected cell or range.