Format Painter Excel: Copy Formatting in Seconds

Why does your carefully formatted source cell look perfect, and the moment you try to match it somewhere else, you're manually adjusting fonts, borders, and fill colors one by one? If you've been there, you've probably also been five minutes into that process before realizing there had to be a faster way. There is. The Format Painter in Excel copies all of that in a single click.

Format Painter copies formatting, not values, not formulas, not the data in the cell. Just the visual and structural properties. Get that expectation set correctly now and the rest of this guide makes sense.

If you're newer to Excel and want context on how formatting fits into the bigger picture, the Excel for Beginners starter guide is worth a read first.

---

What You'll Be Able to Do (and One Thing Format Painter in Excel Will NOT Copy)

After working through the steps below, you'll be able to copy any combination of cell formatting (fonts, font sizes, bold and italic, fill colors, borders, number formats, alignment) from one cell and apply it to any other cell or range. Works in Excel 2016 and later, including Microsoft 365.

Here's the one thing it doesn't do: it won't copy cell values or formulas. If your source cell contains =SUM(A1:A10) and shows $4,200 formatted as currency, Format Painter copies the currency formatting. The formula stays put. I've watched people paste formatting onto a blank cell and then wonder why it was still blank. That's why.

What it does copy is more than most people expect. Number formats, conditional formatting rules, cell borders, merged cell states, and even print-area formatting all transfer. (I caught that last one only because I physically test print layouts on my HP LaserJet before publishing anything, and it's not something most write-ups mention.) For a deeper look at how number formats work under the hood, the number formatting guide covers currency, percentages, and custom formats in full.

---

Step 1: Find Format Painter on the Excel Ribbon and Copy Formatting to One Cell

Where the Format Paintbrush Lives on the Home Tab

Open any Excel workbook and click the Home tab on the ribbon. Look all the way to the left and you'll see the Clipboard group, which contains Cut, Copy, and Paste. The Format Painter icon is the small paintbrush sitting just below the Paste button. That's it. No digging through menus.

How to Apply Formatting to a Single Target Cell

1. Click the cell whose formatting you want to copy. This is your source cell.
2. Click the Format Painter paintbrush icon once on the Home tab.
3. Your cursor changes to a white plus sign with a small paintbrush attached. That's your visual cue that it's active. Beginners often miss this and click somewhere random before reaching the target.
4. Click the destination cell. The formatting applies immediately and Format Painter deactivates on its own.

That's the whole thing for a single cell. One source, one destination, done.

---

Step 2: Double-Click Format Painter in Excel to Copy Formatting to Multiple Cells

Once you've applied formatting to a single cell, the natural next question is: what if I need to apply the same formatting to twenty cells across different parts of the sheet? Clicking Format Painter twenty times is not the answer.

Locking Format Painter On

Double-clicking the Format Painter icon locks it on. The paintbrush cursor stays active after each click, so you can keep applying the same formatting to as many cells or ranges as you want. Press Escape when you're done, or click the icon again to turn it off.

I used Excel for longer than I'd like to admit before I discovered this. It's not labeled anywhere. You just have to know. It's the single most useful thing about this tool, and it's almost completely invisible.

You can also apply formatting to entire rows or columns in locked mode. Just click a row number or column letter while the painter is active.

How to Apply Formatting Across Sheets or a Second Open Workbook

Locked mode works across sheets too. With Format Painter active, click a different sheet tab and click your destination cell. The formatting transfers. For a second workbook, both files need to be open at the same time. You can't paint across a closed workbook.

If the two workbooks use different themes or font sets, some formatting may not transfer cleanly. A font that exists in your source workbook might not exist in the destination, and Excel will substitute something else. If that happens, check Page Layout → Themes and make sure both files are using the same one. As of 2026, this is still a known inconsistency in Microsoft 365 that hasn't been addressed with any automatic fallback.

---

Common Format Painter Mistakes: Why Your Formatting Isn't Copying Correctly

A few stumbling points come up consistently, and most of them have quick fixes.

Single-clicking when you meant to lock it. If Format Painter deactivates after one use and you needed to apply to multiple cells, you just single-clicked. Go back, double-click, try again.

Column width and row height don't transfer. This surprises people. Format Painter copies cell-level formatting, not the dimensions of the row or column. To copy column width, you need Paste Special in Excel's data entry and formatting workflow with the "Column widths" option selected. That's a separate operation.

Conditional formatting behaves unexpectedly. Format Painter will copy conditional formatting rules from the source cell, but the rules reference specific cell addresses. When pasted to a new range, those addresses don't automatically adjust the way formula references do. Check the rules under Home → Conditional Formatting → Manage Rules after pasting and update the "Applies to" range manually if needed.

Merged cells. I dislike merged cells strongly enough that I avoid them in any workbook I build. But if your source cell is merged, Format Painter will copy that merged state, which can cause real problems if your destination range has different dimensions. You'll either get an error or a layout you didn't want. Unmerge the source first, or use Center Across Selection as a cleaner alternative.

Accidentally clicking off before reaching the target. Any click that isn't on a cell destination will deactivate Format Painter. If you click in the formula bar, on a toolbar, or on a blank area of the sheet, it cancels. Just go back to the source cell and start over.

---