How to Use the Format Painter in Word and Excel

This guide shows you how to use the Format Painter in Microsoft Word and Excel to copy formatting—like font styles, colors, borders, and number formats—from one selection to another. You’ll learn the single-click and double-click methods, plus how to apply formatting across multiple areas or entire documents. No prior experience is needed beyond having a document or spreadsheet open.

What You’ll Need

• A computer with Microsoft Word or Excel installed (2010 or later works; the steps are the same for Microsoft 365).
• A document or spreadsheet that already contains the formatting you want to copy.
• Text or cells you want to apply that formatting to.

Step-by-Step

1. Select the source of the formatting. Click and drag over text in Word, or click a single cell in Excel that has the formatting you want to copy. For a paragraph in Word, select the entire paragraph including the paragraph mark (¶) to copy paragraph-level formatting like spacing and indents.
2. Find the Format Painter button. In the Home tab of the ribbon, look for the paintbrush icon. In Word, it’s in the Clipboard group. In Excel, it’s also in the Clipboard group, next to Paste. It may be labeled “Format Painter” when you hover over it.
3. Click the Format Painter button once. Your mouse cursor will change to a paintbrush icon. This indicates the tool is active.
4. Apply the formatting. In Word, click and drag over the text you want to format, or click on a word to apply to that word. In Excel, click on a single cell or click and drag across a range of cells. The formatting is applied immediately.
5. Turn off Format Painter. After you release the mouse button, the Format Painter automatically deactivates. Your cursor returns to normal. If you need to apply formatting again, repeat steps 1-4.
6. Use double-click for multiple areas. To apply the same formatting to several separate selections, double-click the Format Painter button instead of single-clicking. The paintbrush cursor stays active even after you release the mouse.
7. Apply to all areas. With the double-click method active, you can select text or cells in different parts of the document or sheet. Click or drag over each target. When you’re done, press the Esc key or click the Format Painter button again to turn it off.
8. Apply to an entire document (Word only). After selecting the source formatting, double-click Format Painter, then press Ctrl+A to select the entire document. This copies the formatting to all text. Note that this can override existing formatting you wanted to keep, so use it carefully.

Common Mistakes

• Selecting only part of a paragraph in Word. If you want to copy paragraph formatting (like line spacing or indentation), you must select the entire paragraph, including the hidden paragraph mark. Otherwise, only character formatting (font, size, bold) is copied.
• Clicking instead of dragging in Word. If you click once on a word, Format Painter applies only to that word. To apply to a sentence or more, drag across the text.
• Forgetting to turn off double-click mode. If you double-clicked and then moved on, you might accidentally format something later. Always press Esc when done.
• Using Format Painter on merged cells in Excel. Format Painter may not copy all formatting attributes correctly when the source or target includes merged cells. It often copies the merged state, which can cause unexpected results.
• Applying to a whole column or row unintentionally. In Excel, clicking the column letter or row number header will select the entire column or row. If you do this while Format Painter is active, it will format that entire range, which may be more than you intended.

Tips

• Use keyboard shortcuts for speed. After selecting the source, press Ctrl+Shift+C to copy formatting, then select the target and press Ctrl+Shift+V to paste it. This works in both Word and Excel and is often faster than using the mouse.
• Format Painter works across documents and sheets. You can copy formatting from one Word document to another, or from one Excel sheet to another, as long as both are open. Just select the source, activate Format Painter, switch to the other document, and apply.
• For Excel, copy number formats too. Format Painter copies number formats (like currency, percentages, dates) as well as fonts and colors. This is handy when you have a properly formatted column and want to apply the same format to a new column.
• Double-click is your friend for repetitive tasks. If you’re formatting a long report with many headings that need the same style, double-click Format Painter once and then click each heading. It saves many trips back to the ribbon.
• Combine with Find and Replace. In Word, you can use Format Painter to copy a style, then use Find and Replace to apply it to all instances of a specific word or phrase. This is a powerful time-saver for large documents.

Troubleshooting

• Format Painter does nothing when you click. Make sure you selected the source correctly. In Word, if you only selected part of a word, it may not copy anything meaningful. In Excel, ensure the source cell actually has formatting beyond the default. Also check that the target is not locked or protected—if the sheet is protected, formatting changes may be blocked.
• Formatting is applied but looks different than expected. This often happens in Word when copying paragraph formatting without selecting the paragraph mark. The target may inherit only character formatting. In Excel, check if the source cell has conditional formatting—Format Painter does not copy conditional formatting rules, only the formatting that is currently visible.
• The paintbrush cursor disappears too quickly. If you single-clicked, it deactivates after one use. Double-click to keep it active. If you double-clicked and it still disappears, check if you pressed Esc accidentally or clicked the button again.
• Format Painter is grayed out (unavailable). This usually means you haven’t selected a source. In Word, you must select some text or an object. In Excel, you must select a cell or range. If you have a chart selected, Format Painter may be disabled; click a cell first.
• Copying formatting to a chart or shape doesn’t work. Format Painter works on text and cells, but not on charts, images, or shapes. For those, use the “Shape Fill” or “Shape Outline” options in the Format tab.

Frequently Asked Questions

1. Can I use Format Painter to copy formatting from one Word document to another? Yes. Select the source, click Format Painter, switch to the other document, and apply. Both documents must be open. The formatting will be copied, but any styles used will also be added to the target document’s style gallery.
2. Does Format Painter copy conditional formatting in Excel? No. It copies the visible formatting (font, fill, borders) but not the conditional formatting rules themselves. You would need to recreate those rules separately.
3. How do I turn off Format Painter after double-clicking? Press the Esc key on your keyboard, or click the Format Painter button again. The cursor will return to normal.
4. Can I use Format Painter with a keyboard shortcut? Yes. Select the source, press Ctrl+Shift+C, then select the target and press Ctrl+Shift+V. This works in both Word and Excel and is a great alternative to the mouse.
5. Why does Format Painter sometimes copy the entire cell’s formatting in Excel, including borders and number formats? That’s by design. Format Painter copies all formatting attributes applied to the source cell, including font, fill, borders, number format, and alignment. If you want to copy only specific attributes, use Paste Special > Formats or the “Format Cells” dialog.
6. Can I use Format Painter on a Mac? Yes. The steps are the same, but the keyboard shortcuts are Cmd+Shift+C and Cmd+Shift+V. The Format Painter button is in the same location on the Home tab.

Related

• Linux Distros Beginners Should Avoid
• Can the Eclipse Ruin Your Phone Camera?
• Jellyfin vs Streaming Services: Which Is Better?