Copy Formatting

How to Copy Formatting in Google Sheets

Google Sheets Training

Google Sheets Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

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.