Format Painter in Excel

How to use Format Painter in Excel?

This tutorial will give you a detail regarding the tool that will help you to speed up the manual formatting. Let us go through 

  • What is Format Painter in Excel?
  • Where do you find Format Painter in Excel?
  • How to use Format Painter in Excel?
  • How to use Format Painter Multiple times?
  • An example of Format Painter in Excel

? What is Format Painter in Excel?

Format painter in Excel is used to copy formatting from one group of cells to another. It is an easy and quick way to apply to format rather than selecting the font, size alignment, color, etc. If you have a cell with some specific font style, specific background and you want to copy that formatting to some other cell you can use format painter in Excel.

? Where do you find Format Painter in Excel?

The Format Painter button is in the Home Tab > Clipboard group > Format Painter.

You can also select this function with the help of a keyboard by going through the following steps:

Press Alt > Press H > Press FP.


Press Alt > Press H > Navigation keys.

? How to use Format Painter in Excel?

Step 1: Select the cell or picture or text that you want to format.

Step 2: Click home, click on Format painter in the clipboard group.

Step 3: After the pointer changes to brush, click and drag to select the text, picture or cell you want to format and then release the mouse.

? How to use Format Painter Multiple times in Excel?

We can use format painter multiple numbers of times in the spreadsheet. The same procedure needs to be followed. Just when you click on the format painter you need to “double-click” it.

Copy Entire Column using Format Painter

You can also select the entire column formatting and paste it to the other cell. You select the entire column > click on format painter > click on column header. You format painter will be applied.

? An Example to explain Format Painter in Excel

The video shows a table that has a variety of format applied. The header has a grey background and bold font type. I have the same data to the left so I choose the entire table by using the Excel Shortcut Ctrl + A to select the entire table. Click on the Format painter and without leaving the mouse click on the data you want to apply to format too. Leave the mouse and the format painter will apply the same format as it is applied to the right table.

? Conclusion:

Format Painter can save a lot of your time and efforts. Now you know how to use the format painter so you can easily use to copy and apply to format from one section to another in a single click.

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.