Using Format Painter tool button Microsoft Excel 2016

How to use Format Painter button MS Excel

format painter definition | format painter excel | format painter shortcut key

See Previous Post: Add numbers addition Microsoft Excel 2016 (adding in excel)

The Format-Painter tool in Home tab ribbon is a fast & effective tool. Significantly, it helps excel users in saving lots of time in Microsoft Excel. Above all, the main role is to apply required formatting of one cell to multiple cells wherever required.

Furthermore, this tool is placed in the first Tab (Home Tab) inside Clipboard Group. Hence, the prime importance of this Tool is self explanatory. Even more, the Cut, Copy and Paste buttons are also present along with this tool in the Clipboard group.

Format Painter tool Clipboard group Excel 2016 – continued

Additionally, the Cut button helps to cut and move content in workbooks. Next, Copy button lets users to copy data in worksheets. While, Paste button pastes the content/data which already have been cut or copied in MS Excel. Also, frequent uses of this button is done in many applicable areas in Excel.

Explicitly, Single clicking will release the Format-Painter button after once it has been used. But, Double clicking makes makes this tool for continuous use, until the “Esc” escape key is pressed by the user. Lastly, let us know what are the uses of this tool in Microsoft Excel.

Format Painter command Home tab MS Excel 2016

  • Apply outline border and cell color.
  • Applying cell color outline border.
  • Used to apply color font.
  • Helps to increase font & decrease font.
  • Used to apply wrap text and merge & center.

See Next Post: Clipboard group Cut Copy and Paste Microsoft Excel 2016

Terms related to this Post:

Format-Painter in Excel Shortcut
Format-Painter in Excel Online
Format-Painter in Excel Mac
Format-Painter-Excel Definition
Format Painter Excel Shortcut


We'd be very grateful to everyone for joining with our IndiaExcel blog. So, below are some of the links to join with us.

Join Us - IndiaExcel Social - Microsoft Excel Tutorials

Excel lovers also're requested from us, to show their Love and Support. Kindly share the posts with your friends, which you liked the most from this Blog.

Thanks & Regards
"IndiaExcel" Blog. ______________________________________________________________________________

About the Author

After working on Microsoft Excel for so many years, now its time to share & spread my Experience and Knowledge, which I have gained on Excel with the world. Myself, Piyush Kr. Pandey is an Excel enthusiast and founder of (Learn Microsoft Excel), a website since 2016. Kindly, Subscribe our blog email newsletters for daily vital and essential informative posts on Microsoft Excel. Email:

Post a Reply

Your email address will not be published. Required fields are marked *