How to Copy Cell Formatting in Excel

Copying cell formatting in Microsoft Excel lets you replicate the look of one cell—fonts, colors, borders, number formats, alignment—onto other cells without retyping or manually reapplying each setting. This guide covers the fastest methods (Format Painter, Paste Special, and keyboard shortcuts) and works in Excel 2016, 2019, 2021, and Microsoft 365.

What You’ll Need

• A spreadsheet with at least one cell that already has the formatting you want to copy.
• The destination cell(s) where you want to apply that formatting.
• Excel open on your computer (Windows or Mac).

Step-by-Step

Method 1: Format Painter (Single or Multiple Cells)

1. Select the cell (or range) whose formatting you want to copy. Click once on it, or drag across a range.
2. Go to the Home tab on the ribbon.
3. In the Clipboard group, click the Format Painter icon (a small paintbrush). The cursor changes to a paintbrush with a plus sign.
4. Click the destination cell to apply the formatting once. For a range, click and drag across the cells you want to format.
5. Release the mouse button. The formatting is applied, and the cursor returns to normal.

Method 2: Format Painter (Multiple Non-Adjacent Areas)

1. Select the source cell or range.
2. Double-click the Format Painter icon instead of single-clicking. The cursor stays as a paintbrush.
3. Click or drag across the first destination area.
4. Click or drag across the second, third, and any other areas. The paintbrush remains active.
5. Press Esc (or click the Format Painter icon again) to turn it off.

Method 3: Paste Special – Formats Only

1. Select the source cell or range.
2. Press Ctrl + C (Windows) or Cmd + C (Mac) to copy it.
3. Select the destination cell or range.
4. Right-click the destination, then choose Paste Special from the context menu.
5. In the dialog box, select Formats (under “Paste�).
6. Click OK. Only the formatting is pasted; the values and formulas are not.

Method 4: Keyboard Shortcut (Windows Only)

1. Select the source cell.
2. Press Ctrl + C to copy.
3. Select the destination cell.
4. Press Alt + E, then S, then T, then Enter. This sequence opens Paste Special and picks “Formats.�

Method 5: Copy Formatting to an Entire Row or Column

1. Select the formatted cell.
2. Click Format Painter.
3. Click the row number (on the left) or column letter (on top) to select the entire row or column.
4. The formatting applies to the whole row or column.

Common Mistakes

• Accidentally copying values too: Using regular Copy/Paste (Ctrl+V) brings values, formulas, and formatting. Use Paste Special → Formats or Format Painter to avoid overwriting data.
• Clicking instead of dragging for a range: If you click a single cell when you meant to format several, only that one cell gets the formatting. Drag across the full range instead.
• Forgetting to turn off Format Painter: After a single use, it turns off automatically. After double-clicking, it stays on—if you forget to press Esc, you may accidentally format cells later.
• Formatting whole columns by mistake: Clicking a column letter formats every cell in that column, which can slow down large sheets and cause unexpected borders or fills far below your data.
• Assuming number formats always copy: Format Painter copies number formats (like currency or dates), but if the destination cell contains a text string, the format may not display as expected until the data is converted to a number.

Tips

• Use double-click for efficiency: When applying the same formatting to many scattered cells, double-click Format Painter and click through them all at once.
• Copy formatting between sheets: Format Painter works across worksheets in the same workbook. Select the source cell, activate the other sheet, and click the destination there.
• Combine with Find & Select: To format every cell that matches a certain value, first use Ctrl+F to find them, then use Format Painter on the first one and click each found cell.
• Use cell styles for repeatable formats: If you frequently apply the same combination, save it as a named style (Home → Cell Styles → New Cell Style). Then applying it is one click, and editing the style updates all cells using it.
• Copy only conditional formatting: Format Painter copies conditional formatting rules too. If you only want the static formatting, use Paste Special → Formats, which does not bring conditional rules in most Excel versions.

Troubleshooting

Format Painter does nothing when I click the destination.
Make sure the source cell actually has formatting beyond the default. If the cell looks plain, there is nothing to copy. Also check that you are not in Edit mode (the cell shows a blinking cursor)—press Enter or Esc to exit, then try again.

Formatting applies to the wrong cells.
Undo with Ctrl+Z. Then re-select the exact destination range before using Format Painter or Paste Special. If you accidentally clicked a row or column header, the whole row/column gets formatted—undo and select only the cells you need.

Number formats copy but the numbers look wrong.
The destination cells may contain text that looks like numbers. Select the destination, open the error indicator (small green triangle), and choose “Convert to Number.� Alternatively, re-enter the values as numbers.

Format Painter copies borders and fills but not column widths or row heights.
Format Painter does not copy column widths or row heights. To copy those, select the entire column(s) or row(s), copy, then use Paste Special → Column Widths (or Row Heights) instead.

Paste Special doesn’t show “Formats� as an option.
This happens if you right-clicked a cell that is part of an Excel Table (ListObject). Click outside the table, or convert the table to a range (Table Design → Convert to Range) if you don’t need table features.

Frequently Asked Questions

Can I copy formatting without copying the cell value?
Yes. Use Format Painter or Paste Special → Formats. Both copy only the visual appearance, leaving the destination’s values and formulas untouched.

Does Format Painter copy conditional formatting?
In most Excel versions, yes—Format Painter copies conditional formatting rules along with static formatting. If you want to avoid that, use Paste Special → Formats, which typically does not carry conditional rules.

How do I copy formatting to an entire worksheet?
Select the formatted cell, click Format Painter, then click the small triangle at the intersection of the row numbers and column letters (top-left corner) to select the whole sheet. Release to apply formatting everywhere.

Why does Format Painter not copy the fill color?
Check that the source cell’s fill isn’t from a table style or conditional formatting that overrides normal fills. If it is, copy the table style or adjust the conditional formatting rule instead.

Is there a way to copy formatting between different Excel files?
Yes. Copy the source cell, switch to the other workbook, and use Paste Special → Formats. Format Painter also works across open workbooks.

Can I undo a Format Painter action?
Yes. Press Ctrl+Z (Cmd+Z on Mac) immediately after applying the formatting. Excel undoes the last formatting change.

Related

• Recover Unsaved Word Documents on iPad: Full Guide
• Hidden Folders in macOS: Show, Create, Use
• WhatsApp Chat Export Not Working: Fixes