In the Excel Options dialog box, on the Customize Ribbon tab, in the left column, check the Developer tab: 3.
In the Excel Options Dialog, click Customize Ribbon from the left sidebar. To open the Excel Options dialog box, do one of the following: On the File tab, click the Options button: Right-click in any tab (ribbon) and choose Customize the Ribbon.
Step 2: Click the Excel tab at the top of the screen, then choose the Preferences option. How to show developer tab in Microsoft Excel 2016 Ribbon 1. This article will show you how to add the Developer tab in the Windows version of Excel. Right-click on one of the Ribbon tabs, and you’ll see a new menu come up: Click Customize the Ribbon, and you’ll get a new window: From here, check the box next to Developer and click OK.
These steps will only work for the Mac version of Excel. The fastest way to add the Developer tab to the Ribbon starts with a simple-right click. Select the macro you wish to use, then select Run. Otherwise, you can perform these steps: Select the Developer tab and choose Macros. The steps in this article were performed on a MacBook Air in the High Sierra operating system. If you have set your macro to use a shortcut, simply hold CTRL and press the key you specified as the shortcut key. How to Add the Developer Tab to the Ribbon in Excel 2016 for Mac Our tutorial below will show you how to add the Developer tab in Excel for Mac so that you can gain access to the options that it includes. Excel 2016 for Mac, like all of the other more modern versions of the Excel application, employs a series of tabs at the top of the window that let you navigate through the various settings and tools in the program.īut there is one useful tab that isn’t included in the default set of tabs, and you might be looking for one of the items on that tab if you are trying to do something like create or run a macro.