Format Painter is a useful tool that allows you to copy formatting from one cell and apply it to another cell or range. It saves time and ensures consistent formatting across your worksheet.
Instead of formatting each cell manually, you can copy the format with just a few clicks.
What Does Format Painter Copy?
Format Painter copies formatting such as:
- Font type and size
- Font color
- Bold, Italic, Underline
- Cell fill color
- Borders
- Number format
- Alignment
It does not copy the actual data or formulas — only the formatting.
How to Use Format Painter
Method 1: Single Use
- Select the cell with the desired formatting.
- Go to the Home tab.
- Click Format Painter (paintbrush icon).
- Click the cell where you want to apply the formatting.
The formatting will be applied once.
Method 2: Multiple Use
- Select the formatted cell.
- Double-click Format Painter.
- Click multiple cells or drag over a range.
- Press Esc to stop.
This allows you to apply formatting to multiple areas.
Example
If cell A1 has:
- Bold text
- Blue font color
- Yellow background
Using Format Painter, you can quickly apply the same style to cells B1, C1, and D1.
Why Use Format Painter?
It helps you:
- Maintain consistent formatting
- Save time
- Improve worksheet appearance
- Avoid repeating manual formatting steps
Best Practice Tips
- Use Format Painter for headings and totals.
- Double-click when formatting multiple areas.
- Ensure you select the correct source cell before copying.
Format Painter is a simple but powerful tool that improves efficiency and professionalism in Excel worksheets.