Shortcut Format Painter: Excel & Word Tips
The shortcut for Format Painter in Microsoft Office is Ctrl+Shift+C to copy formatting and Ctrl+Shift+V to paste it (on Windows; on Mac, it’s Command+Shift+C and Command+Shift+V). This works in Excel, Word, PowerPoint, and Outlook, letting you copy formatting from one selection to another without using the ribbon icon.
Why the Shortcut Matters
Format Painter is a staple tool for anyone who works with documents or spreadsheets. Instead of manually re-applying fonts, colors, borders, and number formats, you can copy the look of one cell or paragraph and apply it elsewhere. The ribbon icon (a paintbrush) is fine for occasional use, but the keyboard shortcut is much faster when you’re formatting multiple areas. It also works across different Office applications, so once you learn it, you can use it everywhere.
How the Shortcut Works in Excel
In Excel, the shortcut copies all formatting from the selected cell or range, including font, size, bold/italic, fill color, borders, number format (like currency or percent), and alignment. Here’s the step-by-step:
- Select the cell or range that has the formatting you want to copy.
- Press Ctrl+Shift+C (Windows) or Command+Shift+C (Mac).
- Select the target cell or range where you want to apply the formatting.
- Press Ctrl+Shift+V (Windows) or Command+Shift+V (Mac).
Unlike the ribbon’s Format Painter (which copies once and then turns off), the shortcut stays active for multiple pastes until you press Esc or perform another action. This is a huge time-saver when formatting many non-contiguous cells.
How the Shortcut Works in Word and PowerPoint
In Word and PowerPoint, the shortcut copies character and paragraph formatting. For example, if you have a heading with a specific font, size, color, and spacing, you can copy that formatting to another heading. The process is identical:
- Select the text with the formatting you want to copy (including the paragraph mark if you want paragraph-level formatting like spacing).
- Press Ctrl+Shift+C.
- Select the target text.
- Press Ctrl+Shift+V.
In Word, the shortcut also copies the paragraph style (like Heading 1) if the text uses one. In PowerPoint, it works on text boxes and shapes, copying fill, outline, and text formatting.
Common Problems and Solutions
Users often run into a few issues:
- Shortcut doesn’t work in Excel – This can happen if you have a third-party add-in that overrides the shortcut. Try closing other programs or restarting Excel. Also, ensure you’re not in cell edit mode (press Enter or Esc first).
- Formatting doesn’t paste as expected – The shortcut copies everything, including conditional formatting in Excel. If you only want certain aspects, you may need to use Paste Special (Ctrl+Alt+V) and choose the specific format type.
- Shortcut only works once – In some versions, the shortcut may not stay active for multiple pastes. If that happens, press the shortcut again before each paste, or use the ribbon’s Format Painter for a single copy.
- Mac vs. Windows – The shortcut uses the Command key on Mac, not Control. If you’re using a Mac keyboard with a Windows PC, the physical key may be different.
Format Painter vs. Paste Special
Format Painter is the quickest way to copy all formatting from one place to another. However, if you need more control, Excel’s Paste Special (Ctrl+Alt+V) lets you choose specific formatting elements, such as values, formulas, or column widths. For example, if you want to copy only the number format but not the fill color, Paste Special > Formats is better. The shortcut is best for copying everything at once.
Alternatives and Advanced Tips
If you find yourself using Format Painter frequently, consider these alternatives:
- Cell Styles in Excel – Create a custom style and apply it with one click.
- Formatting Shortcuts in Word – Use Ctrl+Shift+N to apply Normal style, or Ctrl+Space to clear character formatting.
- F4 Key – In Excel and Word, pressing F4 repeats the last action, including formatting changes. This is useful if you’re applying the same change to multiple cells.
- Double-click the Format Painter icon – If you prefer the mouse, double-clicking the paintbrush icon locks it on for multiple applications.
Frequently Asked Questions
Does the shortcut work in Google Sheets? No, Google Sheets doesn’t support Ctrl+Shift+C/V for formatting. Instead, use the paint roller icon or Ctrl+Alt+C then Ctrl+Alt+V (which copies and pastes formatting only).
Can I copy formatting to multiple non-adjacent cells in Excel? Yes, with the shortcut, after pressing Ctrl+Shift+V, you can continue selecting new cells and pressing Ctrl+Shift+V again. The copied formatting stays in the clipboard until you copy something else or press Esc.
Why does the shortcut copy values instead of formatting in Excel? This happens if you have a custom keyboard shortcut assigned in your Excel options. Check File > Options > Customize Ribbon > Keyboard Shortcuts to see if Ctrl+Shift+C/V are assigned to something else.
Does the shortcut work in Outlook? Yes, it works in the Outlook email editor for text formatting, but not for attaching files or other non-text elements.
Is there a way to copy formatting without the keyboard? Yes, the Format Painter icon on the Home tab works the same way. Click it once to copy, then select the target. Double-click it to keep it active for multiple targets.