Format painter shortcut key

The Excel format painter shortcut key is helpful when you want to copy the cell format quickly but don’t want to use the ribbon icon.

The format painter key sequence is:

Windows shortcut

Alt H F P

Mac shortcut

Not available

There is no format painter shortcut for Mac Excel. The workaround for Mac: First, create a macro to paste formatting. Next, assign a keyboard shortcut to the macro. From now on, you can use the format painter shortcut without any trouble.

How to use the Format Painter Shortcut key in Excel

  1. Select the source cell from which the format is to be copied.
  2. Press the Alt, H, F, P key sequence
  3. The Format Painter icon will appear
  4. Select the target cell(s) and copy the format by clicking the mouse.

That’s all!

Here is an example:

excel format painter shortcut key

You can also reach the format painter command using the Home Tab, Clipboard Group.

home tab clipboard group

Shortcut for older Excel versions

If you are working with an older version of Microsoft Excel, use the steps below:

  1. Select the source cell and press Ctrl + C
  2. Select the target cell(s) where you want to paste the format.
  3. Press the Alt, E, S, T key sequence, and press Enter.

Recommended articles:

Istvan Vozar

Istvan is the co-founder of Visual Analytics. He helps people reach the top in Excel.