Excel Format Painter Shortcut: Keyboard and Ribbon Options

In Excel for Microsoft 365 on Windows, use the ribbon key sequence Alt, H, F, P to activate Format Painter; press the keys one after another, not as a single held-down combination. Excel does not provide a dedicated one-keystroke Format Painter shortcut, so you can also click Home > Format Painter.

The Windows keyboard sequence

The shortcut works through Excel’s ribbon Key Tips. Press Alt to display the available Key Tips, then press H to select the Home tab, followed by F and P for Format Painter. If your ribbon or Excel version displays different prompts, follow the letters shown on screen; Key Tips can vary with interface changes or customization.

After you activate Format Painter, the pointer changes to indicate that formatting is ready to apply. Select or drag over the destination cell or range. Excel applies the source formatting there, while leaving the destination’s values and formulas in place. The keyboard sequence starts the tool; it does not choose the source or destination for you.

A practical sequence is:

Select the cell or range whose appearance you want to copy.
Press Alt, H, F, P, one key at a time.
Select the destination cell or drag across the destination range.

Using Format Painter from the ribbon

The ribbon is often the simplest option if you do not use Key Tips regularly. Select the source cell or range, open Home, and click Format Painter in the Clipboard group. Then click a destination cell, or drag across a range to apply the formatting to all of it. The source selection matters: selecting one cell copies that cell’s formatting, while selecting a range can copy a pattern of formatting across a corresponding destination range.

For example, suppose B2 has a bold font, pale blue fill, and a date number format, and you want those visual settings on D2. Select B2, click Format Painter, and click D2. D2 keeps its own value or formula but takes on the copied appearance. If the source contains a formatted multi-cell pattern, make a destination selection of the matching size where possible so the pattern is applied as intended.

The command is on the Home tab in desktop Excel for Windows and Mac. In Excel for the web, use the Home tab’s Format Painter button when it is available in the ribbon. Ribbon placement can shift when the window is narrow or the ribbon is simplified, so expanding the ribbon may make the command easier to find.

What formatting does it copy?

Format Painter transfers cell formatting rather than cell contents. Depending on the source, that can include the font and font color, fill color, borders, alignment, text wrapping, and number format. A number format is especially useful to copy: a value such as 0.25 can be displayed as 25% in one cell and as 0.25 in another, even though the underlying value is unchanged.

It does not copy the source cell’s text, number, or formula as a replacement for the destination’s content. If A1 contains a formula and you paint its formatting onto A2, A2’s existing formula remains. This is different from copying and pasting cells, which can transfer contents as well as formatting depending on the paste option.

Formatting can include settings that are less obvious than color or font, such as alignment and number display. Take care when applying a whole cell’s formatting to a destination that has a different purpose. Painting a date format onto a cell containing a plain number, for instance, may make the number display as a date serial rather than as the number you expected. The stored value has not necessarily changed; its display format has.

Applying the same format to several places

By default, a single click on Format Painter lets you apply the copied formatting once. If you need to paint several separate cells or ranges, double-click the Format Painter button instead. Then click or drag over each destination in turn. When you are finished, press Esc or click the Format Painter button again to turn the tool off.

This is useful when standardizing headings that are not next to one another. For example, select one correctly formatted section heading, double-click Format Painter, and apply its style to several other heading cells. You do not need to return to the source before each application. Check the results as you go, especially if the targets have different number formats or existing borders that you want to preserve.

Format Painter is intended for applying the source appearance to a destination, not for building a reusable design system. If you are formatting many cells across a workbook, applying a cell style or using a consistent table style can be easier to maintain than painting each location individually.

Format Painter compared with Paste Special

Format Painter is quick when you want to copy appearance from one selected area to another without copying the source’s contents. Copy and Paste Special gives you more control when the source cell is already copied or when you need to choose exactly what to paste.

On Windows, copy the source with Ctrl+C, select the destination, and press Ctrl+Alt+V to open Paste Special. Choose Formats in the dialog and confirm. This pastes formatting rather than the copied values or formulas. The dialog is useful when you want a particular paste behavior, but it takes more steps than Format Painter. Press Esc to leave copy mode if the moving border remains after the operation.

Use ordinary copy and paste when you want the cell contents as well as formatting, or when you want to choose among other paste options. Use Format Painter when the task is simply to make a destination look like a source. These tools are related, but they are not interchangeable: copying a cell and pasting normally can overwrite destination content, while Format Painter is designed to leave that content intact.

Common problems and how to fix them

The sequence seems not to work: press the keys in order rather than holding Alt, H, F, and P together. Press Alt first and watch for the Key Tips. If your ribbon layout differs, follow the letters Excel displays or use the button.
Nothing changes after activation: Format Painter still needs a destination. Once activated, click the target cell or drag across the target range.
Only one destination receives the format: a single click on the button normally applies the format once. Double-click the button to keep it active for multiple destinations, then press Esc when done.
A number displays unexpectedly: the copied number format may be inappropriate for the destination’s value. Apply a suitable number format from the Number group on the Home tab.
The result does not match the source exactly: inspect the selected source area and the size of the destination. A multi-cell source can contain different formatting across its cells, and the target shape affects how the pattern is applied.

Conditional formatting is a separate feature from ordinary font, fill, and border settings. If a cell’s appearance is controlled by a rule, the visible result may depend on the cell’s value and the rule’s range or references. After painting cells that use conditional formatting, check Home > Conditional Formatting > Manage Rules if the result differs from what you expect. This helps distinguish a copied static format from an appearance being controlled by a rule.

Using the shortcut on Mac and in Excel for the web

On Excel for Mac, use Home > Format Painter rather than relying on the Windows Alt-based Key Tip sequence. Ribbon keyboard access differs between Mac and Windows, and the Windows sequence is not a universal Mac shortcut. The same basic workflow applies: select the source, activate Format Painter, and select the destination. Double-click the button to apply the formatting to multiple destinations, then press Esc to stop.

In Excel for the web, the ribbon button is the dependable way to access the feature. Keyboard behavior can depend on the browser and on whether focus is in the worksheet or ribbon, so the desktop Windows sequence should not be assumed to work identically in a browser. If the button is hidden in a compact ribbon, expand the ribbon or look in the Home tab’s Clipboard area.

When another formatting method is better

For repeated formatting across a workbook, consider whether you need a one-time copy or a consistent rule. Format Painter is efficient for a few targets, such as matching several labels to one heading. A cell style is more suitable when you want a named format that can be applied repeatedly. Table styles help give structured data a consistent appearance, and conditional formatting is the better choice when appearance should change in response to values, such as highlighting overdue dates.

These alternatives solve different problems. A style provides a reusable set of formatting choices; conditional formatting responds to data; Format Painter copies the appearance of a selected source at that moment. Choosing the right method reduces later cleanup, especially in shared workbooks where other people may need to understand or update the formatting.

Frequently Asked Questions

Is there a single keyboard shortcut for Format Painter in Excel?
No. In desktop Excel for Windows, the ribbon Key Tip sequence is Alt, H, F, P. It is a series of key presses, not a single shortcut pressed simultaneously.

Do I hold down Alt while pressing H, F, and P?
No. Press Alt to show the Key Tips, then press H, F, and P in sequence. Follow the letters shown in your own ribbon if they differ.

How do I use Format Painter more than once?
Double-click the Format Painter button on the Home tab, then apply the formatting to each destination. Press Esc or click the button again when you have finished.

Does Format Painter copy formulas or values?
No. It is for formatting, so the destination’s contents remain in place. Use copy and paste if you intend to transfer a formula or value as well.

What is the Mac shortcut for Format Painter?
The Windows Alt, H, F, P sequence is not the Mac equivalent. On a Mac, select the source and use Home > Format Painter, then select the destination.

Why did Format Painter change how a number looks?
It may have copied the source’s number format along with its other formatting. The underlying value can remain unchanged; choose the appropriate number format on the Home tab to correct its display.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.