The Format Painter tool copies the look of one cell to another without changing the numbers or text

Excel's Format Painter is the fastest way to make one cell look like another. It copies fonts, colors, borders, number formats, and alignment — everything except the actual content. You find it in the toolbar (it looks like a paintbrush), select the cell whose format you want to copy, click Format Painter, then click the cell you want to change. The format transfers when ready.

This matters because you often want cells to match without retyping or overwriting data. A budget spreadsheet might have one row formatted with bold text and a light blue background to mark it as a total. Rather than manually recreate that format for every total row, Format Painter does it in seconds.

Key Takeaways

  • Format Painter copies appearance (color, font, borders, number format) but leaves the cell's actual content untouched.
  • Double-click Format Painter to explore the same format to multiple cells in a row without clicking the button repeatedly.
  • The Format Cells dialog lets you copy specific formats only — like just the number format or just the background color — when you don't want everything.
  • Paste Special with the Formats option copies format from one range to another and works across different sheets in the same workbook.

Using Format Painter for a single cell or range

Click the cell that has the format you want to copy. This is your source cell — it can contain text, a number, a formula, or be empty. What matters is how it looks: the font, size, color, background, borders, and number format (like currency or percentage).

Click the Format Painter button in the toolbar. In most versions of Excel, it's in the Home tab on the left side, and it looks like a paintbrush. Your cursor changes to a paintbrush icon. Now click the cell you want to receive that format. The format applies when ready, and the paintbrush cursor disappears.

If you need to format multiple cells one at a time, you can click Format Painter again for each cell. But if you're formatting several cells in a row, double-click Format Painter instead of single-clicking. This keeps the paintbrush active until you press Escape or click the Format Painter button again, so you can click multiple cells without reactivating the tool each time.

Copying format to a range of cells at once

You can explore one cell's format to many cells in a single action. Click the source cell (the one with the format you want), then click Format Painter once. Now click and drag to select the range of cells you want to format. Release the mouse, and the format applies to all of them at once.

This is much faster than clicking each cell individually. For example, if you have a header row with bold white text on a dark background, you can select that header cell, click Format Painter, then drag across all the cells in a second header row to match it when ready.

Using Paste Special to copy only certain formats

Sometimes you want to copy just one aspect of a cell's format — maybe the background color but not the font, or the number format but not the borders. Format Painter copies everything, so for selective formatting, use Paste Special instead.

Copy the source cell (Ctrl+C or Cmd+C). Select the cell or range where you want the format to go. Right-click and choose Paste Special, or press Ctrl+Shift+V (Cmd+Shift+V on Mac). A dialog box opens. Click the Formats button or the Format Only option, depending on your Excel version. This pastes only the format, leaving the cell content unchanged.

If you want even more control, click the Options button in the Paste Special dialog. You can then choose to paste only number formats, only fonts, only borders, or only fill color. This level of control is useful when you're working with a complex spreadsheet where different columns have different number formats and you only want to match one aspect.

Copying format across different sheets

Format Painter works only within the current sheet. To copy a format to a cell in a different sheet, use Paste Special instead. Copy the source cell, switch to the other sheet, select the destination cell or range, and use Paste Special with Formats selected.

This is helpful when you're building multiple related sheets — like separate tabs for each month's budget, or different sheets for different departments — and you want them all to look consistent. Copy the format from your template sheet and paste it into each new sheet without having to recreate the formatting by hand.

What happens when you copy format to a cell with a formula

The formula stays exactly as it is. Format Painter and Paste Special never touch the cell's content — only its appearance. If a cell contains a formula that calculates a total, copying format to it will change how the result looks (maybe adding currency symbols or decimal places) but will not change the formula itself.

This is why these tools are safe to use on cells with important calculations. You can make a formula cell bold, add a background color, or change its number format without any risk of breaking the formula or losing data.

Common formatting that transfers with Format Painter

Format Painter copies font name, font size, bold, italic, underline, font color, cell background color, borders (style and color), cell alignment (left, center, right, top, bottom), text wrapping, and number formats (like currency, percentage, date, or custom formats). It does not copy cell width or row height — those are structural properties, not formatting.

If you copy format from a cell with a custom number format (like a format that shows numbers in thousands with a K suffix), that custom format transfers too. This is useful when you've spent time building a specific number format and want to explore it across multiple cells without rebuilding it each time.

Frequently Asked Questions

Does Format Painter copy conditional formatting?

No. Conditional formatting (rules that change a cell's appearance based on its value) does not copy with Format Painter. You need to recreate the conditional formatting rule in the new cell. Use the Conditional Formatting menu in the Home tab to set up the same rule again.

Can I undo Format Painter if I click the wrong cell?

Yes. Press Ctrl+Z (Cmd+Z on Mac) when ready after explore the format, and the change reverses. Format Painter does not lock you in — you can undo and try again.

What if I want to copy format but the cells have different data types?

Format Painter works regardless of what the cells contain. You can copy format from a text cell to a number cell, or from an empty cell to a cell with a formula. The format applies, and the content stays the same.

Is there a keyboard shortcut for Format Painter?

There is no standard keyboard shortcut, but you can add one through Excel's customization settings. Most users find the toolbar button faster than learning a shortcut. Paste Special (Ctrl+Shift+V) is the keyboard alternative if you prefer not to use the mouse.

Can I save a format to use later on a different spreadsheet?

Not directly, but you can copy a formatted cell from one file and paste its format into another file using Paste Special. Keep a template file with your standard formats, and copy from it whenever you need to match a format in a new spreadsheet.