Paint Format Shortcut in Google Sheets

Paint Format copies the look of one cell (font, color, borders, number format) and stamps it onto another cell. The value or formula in the target cell stays the same; only the styling changes.

It’s handy when you’ve styled one cell or row exactly right and want that look repeated across the rest of the sheet without touching any data.

There is no built-in keyboard shortcut for Paint Format on Windows or Mac. The fastest route is the toolbar paint-roller icon, walked through in the steps below.

Is There a Keyboard Shortcut for Paint Format in Google Sheets?

Paint Format Keyboard Shortcut (Windows Windows)

No native keyboard shortcut on Windows. Use the toolbar paint roller below.

Paint Format Keyboard Shortcut (Mac Mac)

No native keyboard shortcut on Mac. Use the toolbar paint roller below.

Google Sheets has no keyboard combo for Paint Format on either platform. The quickest way to get it done is the paint-roller icon in the toolbar. It copies font family, size, weight, color, cell fill, borders, alignment, and number format in a single click.

How to Paint Format in Google Sheets (Step by Step)

  1. Select the cell whose styling you want to copy.
  2. Click the paint-roller icon in the toolbar. Your cursor changes to a paint roller.
  3. Click the cell (or drag across a range) where the styling should land.
  4. The styling applies and the paint roller turns off after one application.

To paint the same style onto multiple separate ranges in one go, double-click the paint roller in step 2. It stays active until you press Esc.

Another Way to Copy Formatting

If you’d rather stay on the keyboard:

  1. Select the cell with the styling you want.
  2. Copy it with Ctrl + C (Windows) or ⌘ + C (Mac).
  3. Select the target cell or range.
  4. Open the Edit menu, pick “Paste special”, then “Paste format only”.

This applies the styling without touching the value, the same as Paint Format.

Things to Watch For

  • Paint Format copies styling, not data validation. Dropdowns, checkboxes, and conditional formatting rules stay with the source cell.
  • Conditional formatting wins over Paint Format. If a cell has a colour driven by a rule, Paint Format’s fill colour shows up only where the rule isn’t firing.
  • Double-click keeps it active. A single click on the paint roller paints once and quits. Double-click stays on until you press Esc.
  • Number formats travel. Painting a cell formatted as currency onto a plain number cell flips the target to currency. Useful, but easy to do by accident.

Google Sheets keyboard shortcuts

Related Google Sheets shortcuts: