It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007. It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface. You can use Office 2007/2010/2013/2016 immediately without any training. Click the OK button to finish customizing.įigure 2: Add Developer Tab into Excel 2010 Ribbonīrings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365.At the right, select the Main Tabs from Customize The Ribbon drop down box.Click the Customize Ribbon at the left.Click the Options at the left to enter into Excel Option window.How to add Developer Tab into Excel 20 Ribbon: Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option.įigure 1: Add Developer Tab into Excel 2007 Ribbon.Click the Excel Option button at the bottom, then you will enter the Excel Option window.On the Developer tab, click on Insert, ActiveX Controls, and. If it isn’t, click on the Office button (upper, left-hand corner), then on Excel Options (bottom of that screen) and under Top Options for working with Excel place a check next to Show Developer tab in the Ribbon. How to add Developer tab into Excel 2007 Ribbon? In Excel 2007, first be sure the Developer tab is open on the Ribbon.

Classic Menu for Office Home and Business.Classic Menu for Office 2007 Applications.Repeat the process till you have put all the commands you want in your new tab.Now, choose the command, select it and click ADD, which will shift the command from the left hand side to our new group.Select ALL COMMANDS from the DROP DOWN at the top.After selecting the TARGET GROUP on the right side, we are ready to choose and add the commands to our newly created group under our custom tab.Select the group on the Right side List.CHOOSING THE COMMANDS AND ADDING THEM TO THE TAB. If you want to select from the complete exhaustive list of the options, go for ALL COMMANDS. For exampleĬOMMANDS NOT IN THE RIBBON, MACROS, ETC. On the left hand side, there is a long list of AVAILABLE OPTIONS which can be put in our custom tab.Īt the top there is a drop down from which we can select the group of the commands available as per choice. Now, let us add some functions to this tab so that we can save our time by directly using these functions.

Till now we have already created a new CUSTOM TAB in RIBBON of MICROSOFT EXCEL and a group named. STEPS TO RENAME THE GROUP AND ADD COMMANDS TO THE NEW TAB IN RIBBON

How to add developer tab in excel 2007