Where is Format Menu in Microsoft Excel 2007, 2010, 2013, 2016 and 2019?
- Quickly get Format Menu if you have Classic Menu for Office
- If you do not have Classic Menu for Office
How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365?
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:
Figure: Classic Menu brings Format Menu into Ribbon
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:
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|
|9||Edit Cell Styles|
|10||Themes||Page Layout tab > Theme group|
|14||Arrange||Page Layout tab > Arrange group|
|15||Show Phonetic Field|| Home Tab > Font group
More Tips for Microsoft Excel 2007, 2010, 2013, 2016 and 2019
- 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
Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013 and 2016. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013 and 2016 have been added into the classic interface.
It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013 and 2016.
It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.