Chat with us, powered by LiveChat

Copy Formatting

How to Copy Formatting in Google Sheets

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