30 Advanced Excel Tips for 2026

Excel Champs / Excel Keyboard Shortcuts / Format Painter (Excel Shortcut)
By Puneet Gogia (Microsoft MVP)

Format Painter (Excel Shortcut)

Select the formatted cell, press Alt, H, F, P (one key after another) to pick up Format Painter, then click or select the cells to format. This is the key-tip route to Home → Format Painter.

To keep the brush active for several ranges, double-click Format Painter on the Home tab, apply it as many times as you need, and press Esc to turn it off.

For a keyboard-only alternative, copy the source with Ctrl + C, select the target, press Ctrl + Alt + V to open Paste Special, then press T (Formats) and Enter. The copy stays live, so you can repeat it on other ranges.

Both methods copy every format: fill, font, borders, number format and conditional formatting. Painting a date cell onto plain numbers turns them into dates, and repeated painting can leave duplicate conditional formatting rules, so check Home → Conditional Formatting → Manage Rules afterwards. Press Ctrl + Z to undo a paint.

Column widths are copied only when you paint whole columns. For widths alone, copy the source, press Ctrl + Alt + V, then W and Enter.

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

Format Painter in Excel is a feature that is used to copy and paste only the formatting of the cells.

It copies and pastes all the formatting applied to the cells, like background color, font color, font size, borders, number format, etc. So, with this, users can paste only the cell formatting and leave out the value.

Users can use Format Painter manually or with keyboard shortcuts, and in this tutorial, we have explained the keyboard shortcuts to use Format Painter.

Keyboard Shortcut to Format Painter in the Excel

You will find multiple keyboard shortcuts to use Format Painter, but we have explained the best and quickest keyboard shortcut below. Strictly speaking, it uses Paste Special ➜ Formats, which pastes the same formatting that Format Painter does:

Ctrl + Alt + V → T

Steps to Format Painter Using Keyboard Shortcut

  1. First, go to the cell or range of cells whose formatting you want to copy and press the Ctrl + C keys to copy the cells.
  2. After that, go to the cell where you want to paste the cell formatting, press and hold the Ctrl + Alt keys, and then press V to open the “Paste Special” dialog box. Then release the keys.
  3. Now, press T to move the radio button to the “Formats” option, and then press the Enter key and your formatting will get pasted.
paste-special-dialog-box

Use the Format Painter Button with the Keyboard

  1. First, select the cell whose formatting you want to copy.
  2. After that, press Alt → H → F → P to pick up the formatting with Format Painter (Home ➜ Clipboard ➜ Format Painter).
  3. Next, select the cell or range where you want the formatting with the arrow keys (hold Shift to select a range).
  4. In the end, press Enter to apply the formatting.

To apply the same formatting to several places, double-click the Format Painter button on the Home tab instead of clicking it once. It stays on until you press Esc or click the button again.

On a Mac, there’s no Alt shortcut for this. Use Command + C, and then Command + Control + V to open Paste Special and choose Formats.

Frequently Asked Questions

Does Format Painter copy conditional formatting?

Yes. It copies the conditional formatting rules along with the other formatting, and the copied rules apply to the new range.

Does Format Painter copy column width?

Not when you copy single cells. If you select the whole column header and use Format Painter on another column header, the column width is copied too. You can also use Paste Special ➜ Column widths.

Can I undo Format Painter?

Yes, press Ctrl + Z right after you apply it, and the old formatting comes back.

Leave a Comment