Home > Document > Excel > Where is Format Painter in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

 

Where is Format Painter in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

• Easily find out Format Painter button if you have Classic Menu for Office
• If you do not have Classic Menu for Office

If you need to copy formatting from one place, and apply this formatting to other places frequently, the Format Painter command may be a good helper to ease your work. Here we provide your two methods to seek for Format Painter in Microsoft Excel 2007/2010/2013/2016/2019 Ribbons.

Easily find out Format Painter button if you have Classic Menu for Office

Classic Menu for Office will enable your use habits for Excel 2003 still available in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365, because it bring back classic style toolbar and menus under Menus tab. You will find out the Format Painter button stays in the classic toolbar under Menus tab:

Figure 1: the Format Painter button in classic style toolbar

More Classic Menu for Office...

---

 

Find out the Format Painter button in Ribbon if you do not have Classic Menu for Office

If you do not have Classic Menu for Office, you can also find out the Format Painter button in Ribbon easily:

• Click the Home tab;
• Go to the Clipboard group, which stays in the far left of Ribbon;
• Then you will view the Format Painter button.

Figure 2: the Format Painter button in Ribbon

---

More Tips for Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

 

• Where is AutoFormat
• Where is Control Toolbox
• Where is Document Properties
• Where is Edit Menu
• Where is Format Menu
• Where is Insert Menu
• Where is Page Break Preview
• Where is Tools Menu
• More...

 

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

		Classic Menu for Office It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.
		Classic Menu for Office 2007 It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Screen Shot of Classic Menu for Excel