Format Painter Excel Keyboard Shortcut: Master Copying Formatting

Master the Format Painter keyboard shortcut in Excel for Windows and Mac. Learn quick-start steps, practical examples, and tips to copy formatting across cells, sheets, and tables with confidence. Includes cross-platform guidance, pitfalls to avoid, and automation ideas for power users.

Shortcuts Lib Team

February 22, 2026·5 min read

Keyboard Shortcuts Excel Shortcuts Windows Shortcuts Copy Paste Mac Shortcuts

Format Painter Shortcut - Shortcuts Lib — Photo by StockSnapvia Pixabay

Quick AnswerDefinition

The Format Painter keyboard shortcut in Excel lets you copy cell formatting from one area and apply it to another. On Windows, press Ctrl+Shift+C to copy, then Ctrl+Shift+V to paste; on Mac, use Cmd+Shift+C and Cmd+Shift+V. Double-click the painter to lock for extended use or press Esc to exit when you’re done. This is a core productivity technique for precise, repeatable formatting across large worksheets.

What the Format Painter shortcut does in Excel

The Format Painter shortcut is a fast, reliable way to duplicate formatting—such as font, borders, fill color, and number formats—from a source cell to one or more target cells. This is especially valuable when you need to maintain visual consistency across long spreadsheets or multiple worksheets. According to Shortcuts Lib, mastering keyboard shortcuts like the Format Painter can dramatically speed up Excel workflows and reduce repetitive clicking. The keyboard flow is designed for two main actions: copy formatting and apply formatting. When you want to apply the same look to a new area, you activate the copy operation and then paste formatting onto the destination. If you need to format many regions in quick succession, you can lock the painter by double-clicking the Format Painter button in the ribbon, allowing you to continue applying formats without reactivating the command. Use the Esc key to exit once you’re finished.

YAML

windows_copy: "Ctrl+Shift+C"
windows_paste: "Ctrl+Shift+V"
macos_copy: "Cmd+Shift+C"
macos_paste: "Cmd+Shift+V"

Why this matters: consistency saves time and reduces human error in large data projects. The Format Painter shortcut makes it feasible to standardize cell aesthetics across dozens or hundreds of targets without losing track of formatting rules. In practice, this means fewer formatting mistakes and a cleaner, more readable workbook for teammates and stakeholders.

Key concept: copy from one cell, paste to one or many targets
Best practice: combine with selection techniques (Ctrl/Cmd clicking, Shift+Arrow keys) to pick multiple target ranges efficiently
Common mistake: applying formatting to cells with different content or data types, which can obscure data readability

Steps

Estimated time: 10-15 minutes

1
Identify source formatting
Select the cell or range that has the formatting you want to copy. The source formatting includes font, fill, border, alignment, and number formats. This is your style reference for the rest of the task.
Tip: Be sure you’re choosing representative formatting (not just a single characteristic) to preserve overall look when applied.
2
Copy the formatting
Press the copy shortcut to capture the formatting. On Windows use Ctrl+Shift+C; on Mac use Cmd+Shift+C. You won’t see visible changes, but the format data is stored in memory.
Tip: If you’re using Excel with multiple monitors, verify the active workbook to ensure the correct range is captured.
3
Select the target range
Highlight the cells where you want to apply the copied formatting. You can select non-contiguous ranges by holding Ctrl (Windows) or Cmd (Mac) while clicking multiple areas.
Tip: For large selections, use Shift+Arrow keys to extend the selection quickly.
4
Paste the formatting
Apply the copied formatting to the target range. Use Ctrl+Shift+V on Windows or Cmd+Shift+V on Mac. Watch the formatting transfer in real time as borders, colors, and fonts update.
Tip: If some formatting doesn’t apply as expected, check for merged cells or conditional formats that may override styles.
5
Lock painter for multiple applications
Double-click the Format Painter button on the Ribbon to lock it on. This lets you apply formatting across several areas without reactivating the command.
Tip: Remember to press Esc when you’re done to exit painter mode.
6
Exit or continue
If you don’t double-click to lock, press Esc to exit after applying formatting to the desired ranges. If you want to continue, you can reuse Ctrl+Shift+C and Ctrl+Shift+V repeatedly.
Tip: Esc is your quick escape hatch to return to normal editing.

Pro Tip: Use the Format Painter on large worksheets to quickly standardize headers and data cells, ensuring consistent typography and borders.

Warning: Avoid pasting formatting onto cells with conflicting data types (e.g., text formatting on numeric columns) to prevent readability issues.

Note: If you copy across sheets, ensure the destination sheet uses compatible font and color schemes to maintain visual coherence.

Pro Tip: For frequent tasks, consider assigning a macro to automate more complex formatting workflows beyond the built-in painter.

Prerequisites

Required

Excel installed (Windows or Mac), version 2016+ recommended↗
Required
Basic keyboard familiarity with Ctrl/Cmd and Shift
Required

Optional

Optional: dark or light theme preference for comfort during long sessions
Optional

Keyboard Shortcuts

Action	Shortcut
Copy formatCapture the formatting from the currently selected cell or range	`Ctrl`+`⇧`+`C`
Paste formatApply the captured formatting to the selected target range	`Ctrl`+`⇧`+`V`
Exit painter modeCancel formatting transfer if you want to stop early	`Esc`

Questions & Answers

What is the Format Painter keyboard shortcut in Excel for Windows?

In Windows, you copy formatting with Ctrl+Shift+C and apply it with Ctrl+Shift+V. You can double-click the painter button to lock it for multiple pastes. Press Esc to exit painter mode when finished.

What is the Format Painter keyboard shortcut in Excel for Mac?

On Mac, the corresponding shortcuts are Cmd+Shift+C to copy and Cmd+Shift+V to paste. Double-click the Format Painter button on the Ribbon to lock if you plan multiple pastes, and press Esc to exit.

Can I paste only specific formatting, like borders or font color, with Format Painter?

Format Painter transfers all applicable formatting from the source, including font, fill, borders, and number formats. If you need selective formatting, apply a subset manually or use conditional formatting to handle specific rules.

Is there a keyboard-only way to toggle the Format Painter lock?

There is no universal keyboard-only shortcut to lock the painter; you typically double-click the Format Painter button with the mouse. Use Esc to exit painter mode when finished.

Does the Format Painter work across different worksheets or workbooks?

Format Painter can be used within a worksheet or across sheets in the same workbook. To apply in another workbook, you’ll need to switch workbooks and repeat the steps.