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

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

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.


Quickly get Format Menu if you have Classic Menu for Office

If you have installed Classic Menu for Office on your computer, you will find out that you can use the familiar classic menus and toolbar of Excel 2003/XP(2002)/2000 in the Excel 2007/2010/2013/2016/2019 Ribbon. Classic Menu for Office restores all drop-down menus of Excel 2003/XP(2002)/2000, and helps us work easily and quickly. It is easy to find out the Format menu under Menus tab:

shot-Classic Menu brings FormatMenu into Ribbon

Figure: Classic Menu brings Format Menu into Ribbon

More Classic Menu for Office...


 

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

In fact the Ribbon interface has taken place of classic drop-down menus and toolbar since Microsoft Excel 2007/2010/2013/2016/2019 maintains Ribbon, too. So the commands and features listed in Format Menus are grouped into different tabs and groups. Here we will list the positions where original Format Menu items stay in Ribbon Now:

NO.

Original Format Menu items

Position in Ribbon

1 Format Cells… Home tab > Cells group > Format
2 Row Home Tab > Cells group > Format
3 Column Insert tab > Charts group
4 Sheet Page Layout tab > Sheet Options
5 AutoFormat… Not in Ribbon
6 Conditional Formatting Home tab > Styles group
7 Format as Table
8 Cell Styles
9 Edit Cell Styles
10 Themes Page Layout tab > Theme group
11 Colors
12 Fonts
13 Effects
14 Arrange Page Layout tab > Arrange group
15 Show Phonetic Field Home Tab > Font group

Back to Top

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

 

 

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.

Classic Menu for Excel 2010

Screen Shot of Classic Menu for Excel

 

 

 
 

2001- Addintools. All rights reserved.  Privacy Policy  |  Contact Us
If you have any questions or suggestions about our products or web site, please feel free to submit them to us. Thank you very much.