Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

How To Use Format Painter In Excel For Quick Formatting

How To Use Format Painter In Excel For Quick Formatting

Sometimes, you want to copy & apply formatting from one cell or range to another cell or range. We have a very useful tool to copy & paste formatting from one cell or range to another cell or range called Format painter. In this tutorial, I’ll show you how to use format painter in excel.

What is the Format Painter?

Before you learn about how to use format painter in excel, let me give you a simple introduction to it.Format Painter In Excel is a simple & an effective tool to apply formatting from one cell to another cell. For Example: If you have a cell with some specific font style, having a specific background color & you want to copy that formatting to some another cell, you can use format painter to do so.

For Example: If you have a cell with some specific font style, having a specific background color & you want to copy that formatting to some another cell, you can use format painter to do so.

How Does Format Painter Work?

Format painter has a simple phenomenon. When you click on format painter button it will simply copy a cell & when to select another cell it will apply formatting on it.

Where is the format painter button?

For using format painter in excel follow these simple steps.

Go to Home Tab → Clipboard → Format Painter

Learn How To Use Format Painter In Excel To Copy Formatting

How to use format painter in excel?

  • Select the range or cell from where you want to copy the formatting.
  • Click on the format painter button.
  • Once your click on format painter button, your cursor will convert into a paint brush.
  • Now, select the range on which you want to apply formatting.

Learn How To Use Format Painter In Excel to apply formatting

Shortcut Key

You can also use the Shortcut Key Alt + H + F +P for format painter.

Just select the range or cell from which you want to copy format & use shortcut key for format painter.

Can I use Format Painter Multiple Times In Excel?

Yes, you can use it to apply formatting for multiple times.

  • Select the range from where you want to copy formatting.
  • Go to Home Tab → Clipboard → Format Painter.
  • Double Click the format painter button.
  • Now you can paste formatting multiple times.

Learn How To Use Format Painter In Excel Multiple Times

Copy Column Width Using Format Painter Along With Formatting – [Bonus Tip]

  • Select the entire column from where you want to copy formatting & column width.
  • Click the format painter button.
  • Click on the column header of the destination column.

Learn Now To Use Format Painter In Excel To Apply Column Width

Conclusion

Now you know about How To Use Format Painter In Excel. You can use it to copy & apply formatting from one section to another in a single click & save your lots of time.

And, here is a quick question for you?

Do you know about how to use format painter in excel before reading this post?

or you are using Paste Special?

Raise your hand in the comment box.

 

More Awesome Excel Options