How to Use the Format Painter to Copy Styles in Excel

When formatting a complex Microsoft Excel spreadsheet, you might spend several minutes perfectly designing a specific header cell—changing the background to a dark corporate blue, setting the font to bold white Arial, adding a thick bottom border, and centering the text. If you then need to apply that exact same design to twenty other headers scattered randomly across the workbook, manually repeating those five formatting steps on every single cell is an agonizing waste of time. The Excel Format Painter is a built-in tool designed specifically to copy the visual style of one cell and “paint” it instantly onto others, completely ignoring the underlying data.

Using the Format Painter for a Single Cell

If you only need to copy your beautifully designed format to one other location, the standard single-click method is fastest.

1. Click once on the cell that contains the perfect formatting (your “source” cell).
2. Look at the main ribbon menu at the top of the screen. Ensure you are on the Home tab.
3. On the far left side, in the “Clipboard” group, click the Format Painter button (it looks like a small yellow paintbrush).
4. Your mouse cursor will immediately change to a white cross with a small paintbrush icon attached to it. Notice that the Format Painter button on the ribbon is now highlighted, indicating the tool is active.
5. Click once on the new cell (your “target” cell) that you want to format.

The target cell will instantly adopt the background color, font size, borders, and alignment of the source cell. The text or numbers inside the target cell will not change. Once you click the target cell, the paintbrush cursor disappears, and the tool automatically turns itself off.

Using the Format Painter for Multiple Cells (The Double-Click Trick)

The single-click method is frustrating if you need to apply the format to ten different cells that are not next to each other, because the tool turns itself off after the first click. To keep the paintbrush loaded with your format indefinitely, you must use the double-click trick.

1. Click on your perfectly formatted “source” cell.
2. Move your mouse up to the Format Painter button on the ribbon and double-click it rapidly.
3. Your mouse cursor will turn into the paintbrush icon, but this time, it will stay that way.
4. Click on target cell A. The format applies.
5. Click on target cell B. The format applies.
6. Click and drag your mouse across target cells C, D, and E to format a block of cells simultaneously.
7. When you are finally finished formatting your spreadsheet, press the Esc (Escape) key on your keyboard to drop the paintbrush and return your cursor to normal.

What the Format Painter Cannot Copy

While the Format Painter copies almost everything (fonts, colors, borders, number formats like Currency or Dates, and even text alignment), there are two critical things it cannot copy:

• Column Width and Row Height: If your source cell is stretched wide to fit a long title, painting that format onto a narrow column will not resize the column. You must resize columns manually.
• Conditional Formatting Logic: If a cell is red because of a conditional formatting rule (e.g., “turn red if value < 0”), the painter will copy the rule, not the static red color. If you paint it onto a cell containing a positive number, it will remain white.