Need Help? Chat with us

Format Painter in Excel

[vc_row][vc_column width=”2/3″][vc_column_text]

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

[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

? 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.[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

? 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.[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

? 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.[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

? 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.[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

Learn Full Excel Course in just Rs. 799/-

[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

? 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.[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]

? 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.[/vc_column_text][vc_empty_space height=”5px”][/vc_column][vc_column width=”1/3″][vc_wp_search][vc_column_text]

Learn 100+ Excel Tips & Tricks

“To be an Excel Superstar”

[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]Download ebook

[/vc_column_text][vc_separator border_width=”2″ type=”type_2″][vc_column_text]Topic

[/vc_column_text][vc_wp_tagcloud taxonomy=”post_tag”][/vc_column][/vc_row]

Fatal error: Uncaught Error: Call to undefined function setPostViews() in /home/yodalear/public_html/ Stack trace: #0 /home/yodalear/public_html/ include() #1 /home/yodalear/public_html/ require_once('/home/yodalear/...') #2 /home/yodalear/public_html/ require('/home/yodalear/...') #3 {main} thrown in /home/yodalear/public_html/ on line 10