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.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.