Step 6: Click the Ok button to finish customizing.Step 4: Find out the AutoFormat in commands box and select it.Step 3: select the Commands Not in the Ribbon from the Choose commands from drop down box.Step 2: Click the Customize button (in Excel 2010, it is Quick Access Toolbar) at left bar.Step 1: Click the Office button and Excel Options to open the Excel Options window.In fact, we can add the AutoFormat feature into QAT (Quick Access Toolbar) as a button: Select the second tab named AutoFormat As You Type, and then you can edit the AutoFormat settings.Īdd AutoFormat button into QAT if you do not have Classic Menu.In the AutoCorrect Options pane, click the AutoCorrect Options button.Now you have entered the Excel Options window, click the Proofing button at left bar.Click the Office Button in Excel 2007, and click the File tab in Excel 2010/2013.It takes several steps to get the AutoFormat feature from Ribbon: Then you will view the AutoFormat item.įigure 1: Apply AutoFormat in Classic Menuįind out AutoFormat feature from Ribbon if you do not have Classic MenuĪctually the AutoFormat command is not on the Ribbon of Microsoft Excel 2007/2010/2013.Click the Format drop down menu in main menus.In the classic menu interface, you can get the AutoFormat feature with the same way that you did in Microsoft Excel 2003/XP(2002)/2000:
What’s more, you can easily switch two kind of interface.
With it you can enjoy both interface of classic menus and Ribbon. Classic Menu for Office Home and BusinessĮasily get AutoFormat feature if you have Classic Menu for OfficeĬlassic Menu for Office aims to bring back the familiar user interface of Microsoft Office 2003.Classic Menu for Office 2007 Applications.