MS Excel - Excel Format Painter

1. What is Format Painter?

Format Painter copies cell formatting — not the actual values or formulas — from one place and applies it to another.

Examples of formatting it can copy:

  • Font size, color, style (bold, italic, underline)

  • Cell borders and shading

  • Number formats (currency, date, percentage, etc.)

  • Alignment (center, wrap text, indent)

  • Conditional formatting styles

2. How to Use Format Painter

Method 1: Single Use

  1. Select the cell or range with the formatting you want.

  2. Go to Home → Clipboard → Format Painter (paintbrush icon).

  3. Click once.

  4. Select the target cell(s) → Formatting is applied.

Method 2: Multiple Use

If you want to apply the same formatting to multiple places:

  1. Select the cell with desired formatting.

  2. Double-click on Format Painter.

  3. Apply formatting to multiple cells or ranges.

  4. Press Esc to turn it off.

3. Format Painter Shortcut

Excel doesn’t have a direct single-key shortcut, but there’s a quick way:

  • Alt + H + F + P → Activates Format Painter.

  • Enter or Esc → Deactivates it.

4. Applying Format Painter to Multiple Non-Adjacent Ranges

  • Option 1: Use the double-click trick (explained above).

  • Option 2: Select your source cell → Press Ctrl+C → Right-click target cells → Paste Special → Formats.

5. Using Format Painter with Entire Rows & Columns

  • To format entire rows:
    Select the formatted row → Click Format Painter → Click target row.

  • To format entire columns:
    Select the formatted column → Click Format Painter → Click target column.

6. Format Painter with Conditional Formatting

Format Painter also copies conditional formatting rules.
If you don’t want the rules, use:

  • Home → Paste → Paste Values
    or

  • Paste Special → Values instead.

7. Format Painter for Shapes, Charts, and Objects

It’s not just for cells — Format Painter also works on:

  • Shapes → Copies fill, outline, shadow, and effects.

  • Charts → Copies chart colors, fonts, axis formats, and legends.

Steps:

  1. Select formatted shape/chart.

  2. Click Format Painter.

  3. Click on the new shape/chart.

8. Troubleshooting Format Painter

Issue Cause Solution
It copies formulas accidentally You used normal copy-paste Use Paste Special → Formats
Doesn’t copy conditional colors Rules tied to specific cells Edit rules after applying
Gridlines disappear A fill color was copied Remove fill → Home → Fill → No Fill

9. Best Practices

  • Use Format Painter for quick styling, but for large datasets, prefer Cell Styles or Format as Table for consistency.

  • Use Paste Special → Formats if Format Painter is copying unwanted properties.

  • Use double-click for speed when applying formatting to multiple areas.