Our biggest-ever sale. 60% off AI & data skills
Buy Now
You will notice that your mouse pointer changes into a small paintbrush when you copy the formatting and turns off automatically after applying it.
If you want to apply the same formatting to multiple cells, follow these steps:
To exit Format Painter mode, press Esc, click the Format Painter icon again, or click another tool on the ribbon.
The Format Painter doesn’t have a single dedicated shortcut. However, you can use the following sequence of standard copy and paste.
If using Windows:
Using these keys Alt → H → F → P → activates Format Painter so you can copy it to the required cell.
If you are on a Mac, use Cmd + C followed by Cmd + Ctrl + V to paste formatting only.
Shortcuts are always faster than the mouse when you’re working in large ranges, repeating the same formatting pattern.
Check out the Excel Shortcuts Cheat Sheet to learn how to improve productivity by learning the shortcuts for different Excel features.
As I had stated earlier in the article, the Format Painter in Excel copies visible and structural formatting, including:
You may also notice some inconsistencies when copying between differently sized cells or merged ranges. The column width, row height, and conditional formatting are not always transferred as expected.
The Format Painter in Excel is adaptive and works across rows and columns exactly the same as cells. You just select the formatted row or column, activate Format Painter, then click the target row or column header to apply.
You can also use Format Painter between worksheets in the same workbook. To do this, select the source cell, activate Format Painter, switch sheets, and apply the formatting.
Similarly, Format Painter works across different workbooks but only when both workbooks are open. However, some formatting, such as themes and fonts, may not transfer cleanly if the workbooks use different themes or styles.
Below are common issues I have run into when using Format Painter in Excel that you should be aware of:
I recommend checking out our Conditional Formatting in Google Sheets course to learn how to apply conditional formatting to validate data for getting quick insights.
While the Format Painter is convenient, below are scenarios when you should avoid using it:
Now that you have understood the don’ts of the Format Painter in Excel, here is a checklist to help you keep your workflow clean:
The Excel Format Painter is a fast and efficient way to copy formatting without recreating styles from scratch. It works best for small to medium formatting tasks, such as aligning the look of a few cells or ranges, rather than managing large-scale design changes. If you understand its limits, you’ll avoid frustration and keep your workflows smooth. Always think of the Format Painter as a precision tool for quick, consistent formatting, not a full styling system.
Now that you are ready to explore further, I recommend taking our Data Analysis in Excel course to advance your Excel skills. This course will help you master advanced analytics and propel your career. I also recommend taking our Intermediate Power Query in Excel course to learn about data transformation and using the M language for creating dynamic functions.

Data Science Technical Writer with hands-on experience in data analytics, business intelligence, and data science. I write practical, industry-focused content on SQL, Python, Power BI, Databricks, and data engineering, grounded in real-world analytics work. My writing bridges technical depth and business impact, helping professionals turn data into confident decisions.
No. Format Painter only copies formatting. It does not copy values, formulas, references, or calculations.
There’s no single dedicated shortcut for Format Painter in Excel, but you can use Ctrl + C → Ctrl + Alt + V → T → Enter (Windows) to paste formats only, which works like Format Painter.
Yes. Double-click the Format Painter icon to apply the same formatting to multiple cells, then press Esc to exit.
Yes. You can copy formatting from one worksheet and apply it to another within the same workbook.
Format Painter overwrites existing formatting because it replaces all formatting in the target cell. It doesn’t merge styles or preserve selected attributes.
Tutorial

Tutorial
Tutorial
Learn Excel with DataCamp
Curs
Stăpânește rapid bazele Excel: navighează în foi de calcul, aplică formule, analizează date și creează primele grafice!
Curs
Învață să pregătești datele din Excel cu funcții logice, formule imbricate, funcții de căutare și PivotTable-uri.
Curs
Învață să analizezi datele cu PivotTables și funcții logice intermediare, apoi treci la instrumente precum analiza what-if și prognozarea.
In this guide, I will show you how to use Format Painter in Excel so you can apply formatting quickly without breaking your workflow. It's a great tool, and once you use it you won't go back to copying formats by hand ever again.
If you are getting started in Excel, our Introduction to Excel course covers skills like navigating the interface, understanding data formats, and working with basic functions. Also, I find the Excel Formulas Cheat Sheet, which you can download, is a helpful reference because it has all the most common Excel functions.
What Is Format Painter in Excel?
Format Painter in Excel is a tool that allows you to copy formatting from one cell, range, or object and apply it to another. It copies visual and structural formatting such as font type and size, font color, fill color, borders, alignment, and number formats.
However, the Excel Format Painter does not copy cell values, formulas, references, or underlying data. It will copy only the visual appearance of the data.
Where to Find Format Painter in Excel
On Excel for desktop, you will find Format Painter on the Home tab of the Excel ribbon, in the Clipboard group. The icon looks like a small paintbrush.
If you are using Excel for the web, the tool is also on the Home tab but may be grouped or shown as an icon-only button, depending on screen size.
How to Use Format Painter in Excel (Step-by-Step)
You can use the Format Painter in Excel to copy a format in one cell or multiple cells. I will show you both methods.
Copy formatting to one cell
To copy your cell format from one cell to another:
Select the source cell that already has the formatting you want. For example, click cell
D2.On the Home tab, click Format Painter.
Then, click the target cell where you want to apply the formatting.