Yes, you can paste format in Excel in under two seconds. But if you’re still using Paste Special > Formats with your mouse, you’re adding 12–17 extra clicks per operation — and risking inconsistent borders or font scaling.
The Problem
You receive a sales report from Finance (file: Q3_Sales_Final_v2.xlsx) with clean formatting — bold headers, right-aligned numbers, $ symbols, thin gridlines, and alternating row shading. You need to apply that same look to your own raw data in Sheet2 — but pasting everything breaks formulas, overwrites values, and scrambles conditional formatting.
Worse: you try Format Painter, click once, drag down 50 rows… and notice column D’s currency format didn’t stick. Then you realize merged cells in row 10 broke the paint stroke. You go back, reselect, retry — and now row 12 has double borders.
| Region | Revenue | Date | Account Manager |
|---|---|---|---|
| North America | 45200 | 2024-03-15 | Sarah Chen |
| EMEA | 38900 | 2024-03-18 | Diego Ruiz |
| APAC | 51600 | 2024-03-22 | Amina Patel |
| Latin America | 29400 | 2024-03-25 | Mateo Silva |
| North America | 62100 | 2024-04-01 | Sarah Chen |
| EMEA | 44300 | 2024-04-05 | Diego Ruiz |
This table (A1:D7) has no formatting — plain Calibri 11, no borders, left-aligned text, no number formatting. Your goal: match the style of A1:D7 in the source sheet — which uses Arial 10, bold headers, $#,##0.00 for Revenue, date format dd-mmm, light blue fill (#d9e1f2) for headers, and subtle grey borders.
The Solution
The fastest, most precise method isn’t Format Painter or Paste Special — it’s Alt + E + S + T. That’s the keyboard sequence for Paste Special > Formats. Here’s how to do it cleanly:
- Select the formatted range you want to copy — e.g., A1:D1 (headers) and A2:D7 (data) separately, or together if layout matches exactly.
- Press Ctrl + C.
- Select the destination range — make sure it’s the exact same shape. For our example, highlight A1:D7 in your blank worksheet.
- Press Alt, release, then press E, release, then S, release, then T. You’ll see “Formats” highlighted in the Paste Special dialog — hit Enter.
That’s it. No mouse, no dialog hunting, no accidental paste-values. What makes this elegant is that Excel preserves relative formatting logic: if your source uses cell-based number formats (not column-level), they apply correctly. And unlike Format Painter, this respects merged cells — as long as your destination range includes them in the same positions.
| Region | Revenue | Date | Account Manager |
|---|---|---|---|
| North America | $45,200.00 | 15-Mar | Sarah Chen |
| EMEA | $38,900.00 | 18-Mar | Diego Ruiz |
| APAC | $51,600.00 | 22-Mar | Amina Patel |
| Latin America | $29,400.00 | 25-Mar | Mateo Silva |
| North America | $62,100.00 | 01-Apr | Sarah Chen |
| EMEA | $44,300.00 | 05-Apr | Diego Ruiz |
Notice how row 2 got bold headers but rows 3–7 kept regular weight? That’s because Excel copied only formatting — not values — and preserved the header/data distinction from the source.
Going Further
You can chain this trick. Say you want to paste formats *and* column widths. After step 4 above, instead of hitting Enter, press W (for Column widths), then Enter. Or press V for values — but don’t. That defeats the purpose.
For large reports, use Alt + H + V + T — the ribbon-accessible version (Home > Paste > Paste Special > Formats). It’s slower than Alt+E+S+T, but works even if the Edit menu isn’t visible (e.g., in Excel for Mac or newer UI modes).
Here’s the counterintuitive tip: Paste Special > Formats ignores conditional formatting by default. If your source uses CF rules (e.g., “highlight revenue > $50,000”), those won’t transfer — and that’s intentional. To copy CF, select the source range, press Ctrl+C, then in destination: Alt+E+S+R → Enter. That’s Paste Special > Validation & Conditional Formatting.
When NOT to Use This
Avoid Paste Special > Formats when:
- Your destination has merged cells in different locations than the source — Excel will crash or paste garbled borders.
- You’re applying formatting across sheets with different print areas or page setup — margins, headers, and orientation won’t transfer.
- You need to preserve existing cell comments or data validation — Paste Special > Formats overwrites both. Use Format Painter instead (Alt+H+F+P) if comments must stay.
- The source uses theme-based fonts or colors (e.g., “Heading 1” style). Those rely on workbook-level themes — and won’t map cleanly to a destination with a different theme.
Also: never paste formats into a table (Ctrl+T) unless you’ve first converted it to a range (Ctrl+Shift+T). Tables auto-apply their own banded-row formatting, and Paste Special > Formats will fight it — resulting in duplicate fills or broken stripes.
Keyboard Shortcuts
| Action | Windows Shortcut | Mac Shortcut |
|---|---|---|
| Paste Formats | Alt + E + S + T | Cmd + Option + V → F → Return |
| Format Painter (single use) | Alt + H + F + P | Cmd + Shift + C |
| Paste Column Widths | Alt + E + S + W | Cmd + Option + V → W → Return |
| Clear All Formatting | Alt + H + E + F | Cmd + Option + Space |
