Step 2: Click the Excel tab at the top of the screen, then choose the Preferences option. This article will show you how to add the Developer tab in the Windows version of Excel. These steps will only work for the Mac version of Excel. The steps in this article were performed on a MacBook Air in the High Sierra operating system. Excel displays the same Trust Center Settings dialog box mentioned in the. Select the option called 'Show Developer tab in the Ribbon'. When the Excel Options window appears, click on the Popular option on the left. If you prefer, you can display the Developer tab in Excel and then click the Macro Security tool. To display the Developer tab, click on the Microsoft Office button in the top left of the Excel window and then click on the Excel Options button. How to Add the Developer Tab to the Ribbon in Excel 2016 for Mac Check the settings in the Trust Center (display the Excel Options dialog box, click Trust Center, and then click Trust Center Settings) to make sure that you allow macros.

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. After a module is created then the Design Mode Icon becomes not-grayed. Select the Developer check box under Main Tabs on the right, and then click OK. To do this, follow these steps: Click File, and then click Options. I inserted a control on my sheet and then went to View Code. To use the form controls in Excel 2010 and later versions, you have to enable the Developer tab. Hi sujithr25 and welcome to the forum, I get a grayed out 'Design Mode Icon' until there is a Module. 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. Re: Greyed out controls within the developer tab.

How to view developer tab in excel