How to Use Format Painter to Copy Formatting in Excel

Excel Format Painter is a nifty tool that allows you to copy formatting from a range of cells and paste it somewhere else in the worksheet (or other worksheets/workbooks).

Imagine this!

You get plain ugly data from a colleague, and you spend the next few minutes applying to format to make it beautiful. This may include applying borders, formatting the headers, adjusting column widths, removing gridlines, etc.

And while you’re patting your back for turning ugly data into a beautiful one, you get another file that needs to be formatted the same way.

This is where Excel Format Painter comes into the picture and saves you a lot of time.

You can now quickly copy the formatting you had already done, and paste it to the new dataset.

And woosh.. it will get transformed into the same formatted data where you did everything manually.

In this video, you will learn how to quickly copy formatting from a range of cells to another range of cells. You can also copy conditional formatting using format painter.

---------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:10 Copy Cell from Formatting Using Format Painter
01:11 Copy formatting from one column to another
01:42 Copy and Paste conditional formatting
02:55 Apply formatting to multiple cells/columns (keep format painter active)
03:43 Copy formatting from one shape to another
--------------------------------------------------------------------------------------------------------------------------------------

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[elizabethkagansky]

EXCELLENT TUTORIAL! Thank you so much!

[dilly]

Very helpful and informative. Thank you

[spreadsheethq]

Like your video and training style. I have a passion for using excel too. Subscribed and following.

[ahadsiddiqui]

Great tutorials bro..Thanks for sharing this9 info..Specially over condtinal formating and double click obrthi for format painter..

[narendrasubramanya]

Great tutorial sumit. I learnt a lot from this video. I have another query is it possible to build a pivot table and get the total in the last column as you do with the rows. i.e a1, b1, c1 in my table and I want a pivot table which sums all these. But my table does not contain the total column. Please clarify this. Have a nice day and keep doing this type of informative videos.

[marksummers]

Good. Question: To copy a shape, do I click on the edge of the model shape or anywhere in the cell?

[harshitshukla]

is format painter can work on other sheet with formula or other inserting option

[meetkcs]

Is there any keyboard short cut key for format painting??

In MS Word, we have a keyboard shortcut for the same : ctrl +shift + C
Ctrl+Shift+v....


Like this anything available in excell ??

[xpyder]

Can this function be used across different worksheets?

[rokadebt]

Sir, how to pick up cell formating or font style change by using formula in excel

[jonathanlebrun]

Still does not work with mine. I do not understand.