How to Keep Format Painter On in Excel for Multiple Cells

To keep Format Painter active in Excel, select the cell or range with the formatting you want, then double-click Home > Clipboard > Format Painter. Click or drag over each destination in turn; press Esc when you are finished. This copies formatting without replacing the destination’s values or formulas.

The instructions below are for Excel for Microsoft 365 on Windows. Format Painter is useful when you need to apply the same appearance in several places without repeating the font, fill, border, alignment, or number-format settings by hand. You do not need to change an Excel option or install anything first.

What You’ll Need

An Excel workbook with a source cell or range that already has the formatting you want to reuse.
One or more destination cells or ranges where you want that formatting applied.
Access to Excel’s Home tab. Save the workbook first if you are making extensive changes, especially if the formatting is difficult to recreate.

Step-by-Step

Identify the source formatting. Find the cell or range that looks the way you want the other cells to look. If you want to copy several kinds of formatting together, use a source that already has the complete combination: for example, the desired font, fill color, border, alignment, and number format. Format Painter takes its formatting from this source; it does not combine selected properties from several different cells.
Select the source cell or range. Click a single cell to copy its formatting, or drag across a range if the formatting is arranged across multiple cells. For example, select a formatted table heading row if you intend to reproduce the row’s appearance elsewhere. The source selection should represent the layout you want to copy, not just a nearby cell that happens to have one matching feature.
Open the Home tab. On the ribbon, go to Home and find the Clipboard group, usually at the left side of the ribbon. If the ribbon is minimized or the window is narrow, the group or its labels may be collapsed. Expand the ribbon or widen the Excel window if you cannot see the button.
Double-click Format Painter. Click the paintbrush icon labeled Format Painter twice in quick succession. A single click is for applying formatting once; the double-click keeps the tool active so you can visit more than one destination. After the double-click, the pointer normally changes to a paintbrush when it is over the worksheet. That change is a useful sign that the formatting tool is ready.
Apply formatting to the first destination. For one destination cell, click it. For a destination range, drag across the cells you want to format. Excel applies the source formatting to the area you select. The destination’s existing contents normally remain in place: text, numbers, dates, and formulas are not copied by Format Painter.
Continue to other destinations without selecting the source again. With the paintbrush still active, click or drag over each additional cell or range. For example, after formatting one heading cell, you can apply the same heading appearance to other headings in separate parts of the sheet. Check each area as you go, especially when the destination ranges differ in size or layout from the source.
Turn Format Painter off. Press Esc once you have finished. You can also click the Format Painter button again in many desktop versions of Excel. The pointer should return to its normal shape, and you can resume selecting cells or editing the sheet. If the paintbrush remains visible, press Esc again before continuing.
Check the result. Review a few formatted cells for number display, borders, fills, and alignment. Format Painter may copy more than the feature you were focused on. If a destination looks wrong, use Ctrl+Z immediately to undo the most recent application, then select a better source or a narrower destination and try again.

On Excel for Mac, the Format Painter is also on the Home tab, and double-clicking it is the usual way to keep it active for repeated applications. Press Esc to exit; the Escape key is the same named key on a Mac keyboard. Excel for the web also has Format Painter on the Home tab, but ribbon layout and repeated-use behavior can vary with the browser and current web version. If double-clicking does not keep the tool active in your browser, use the desktop app for repeated applications or apply the formatting one destination at a time.

Common Mistakes

Clicking once and expecting repeated use. A single click generally activates Format Painter for one application. If you need several destinations, double-click the button before going to the worksheet.
Choosing a source that is only partly formatted. The painter copies what the source has, including unwanted details. If the source has a thick bottom border or an unusual number format, those details may appear at the destination too. Inspect the source before activating the tool.
Dragging over the wrong destination area. It is easy to include neighboring cells, especially in a dense worksheet. If you format extra cells, press Ctrl+Z right away, then make a more precise selection. When applying to a large block, zoom in or select carefully before dragging.
Expecting the values or formulas to copy. Format Painter is for appearance, not content. Use copy and paste when you need to transfer cell contents as well, and choose the appropriate paste option if you want only values, formulas, or formatting.
Forgetting that the tool is still active. After the last destination, the paintbrush may remain attached to the pointer. A click intended to select a cell could apply formatting instead. Press Esc before moving on, and confirm that the pointer is no longer a paintbrush.
Using a differently shaped source and destination without checking. When the source and destination ranges have different dimensions, the resulting pattern may not be what you expected. For predictable results, use a source and destination with matching shapes, or copy formatting one cell or one row at a time and review the outcome.

Tips

Think of double-click as a temporary mode. It does not permanently pin Format Painter or change a workbook setting. It keeps the paintbrush ready for a run of formatting tasks, and Esc ends that run.
Use single-cell sources for uniform formatting. If every destination should get one consistent style, selecting one correctly formatted source cell makes it easier to understand what will be applied. A multi-cell source is more appropriate when the arrangement of different formats across the range matters.
Work through destinations in a planned order. List or identify the areas you need to format before double-clicking. Then apply formatting to each one and press Esc. This reduces the chance of leaving the painter active while you move around the workbook.
Undo promptly when the result is wrong. Ctrl+Z on Windows reverses the most recent formatting action. On Mac, use Command+Z. Undo works best immediately; if you have made many later changes, undoing repeatedly may also reverse those changes.
Use Paste Special when you need tighter control. Format Painter is quick for copying a complete appearance. If you need to copy only a particular category, such as number formats, use Excel’s Paste Special options instead. Copy the source, open the destination’s paste options, and choose the specific option you need rather than transferring every format together.
Keep a clean example cell. A dedicated, correctly formatted heading or sample cell can make repeated formatting safer. It should contain the exact formatting you want to reuse and should not have accidental borders, shading, or number formats.

Troubleshooting

Double-clicking does not keep the brush active: Make sure both clicks land on the Format Painter button, rather than one on the button and one on the worksheet. Try clicking at a steady pace, then look for the paintbrush pointer before choosing a destination. If you are using Excel for the web, try the desktop app; web behavior and controls can differ.

The button is missing or hard to find: Select the Home tab and look in the Clipboard group. Maximize the Excel window, expand a minimized ribbon, or look for a compact paintbrush icon if the group has collapsed. If the ribbon is customized, search Excel’s command interface for Format Painter or switch to the standard ribbon layout if available.

Formatting changes only the first destination: The tool was probably activated with a single click. Undo if needed, reselect the source, double-click Format Painter, and then apply the formatting to each destination. Confirm that the paintbrush pointer remains visible between applications.

The destination looks different from the source: Check whether you selected the intended source and whether your destination selection is the correct size. Some appearance is influenced by the destination’s context, such as existing conditional formatting or the layout of a table. Try a small test destination first. If only one attribute is wrong, use the relevant formatting control or Paste Special rather than copying the whole format again.

Values or formulas seem to have changed: Format Painter should apply formatting rather than replace cell contents. If contents changed, you may have used another paste or fill action, or accidentally typed into the cell. Press Ctrl+Z on Windows (Command+Z on Mac) promptly, then inspect the destination and repeat using the paintbrush button.

You cannot get back to normal selection: Press Esc to leave Format Painter. If you still see the paintbrush pointer, press Esc once more. Then click a blank or appropriate cell and confirm that ordinary selection works before continuing.

Frequently Asked Questions

Can I keep Format Painter on for multiple nonadjacent cells?
Yes. Double-click Format Painter, then apply the formatting to one destination or range at a time. Move to the next nonadjacent area and repeat without returning to the source. Press Esc when all destinations are done.

Does Format Painter copy cell contents?
No. It copies formatting, not the text, values, or formulas in the source. The destination’s contents generally stay as they are. Use copy and paste if you need to transfer content, and choose a paste option suited to what you want to bring over.

How do I turn off Format Painter?
Press Esc on Windows or Mac. In desktop Excel, clicking the Format Painter button again can also turn it off. Check that the paintbrush pointer has disappeared before selecting or editing other cells.

Can I use Format Painter on entire rows or columns?
You can select a row or column and apply its formatting to another selection, but consider what else is included and whether the dimensions match. For precise work, select only the relevant cell range rather than whole rows or columns, so you do not unintentionally affect unrelated cells.

Is there a keyboard shortcut for Format Painter?
Excel does not provide a standard single keyboard shortcut that works like the Format Painter button. Use the Home tab and double-click the button for repeated use. Ctrl+Z on Windows, or Command+Z on Mac, can undo an unintended formatting application.

Will it copy conditional formatting too?
Format Painter can transfer formatting associated with cells, but the visible result of conditional formatting depends on the rules and the destination data. If the appearance comes from a conditional formatting rule, check Home > Conditional Formatting > Manage Rules to review which rule applies and whether its range needs to be changed.

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.