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. Go to the FILE option (top of the left-hand side of the excel). If the Developer tab is not showing, then follow the below steps to enable the Developer tab. To add/enable developer tab in excel 2007, 2010, 2013, 2016 & excel 2011 For Mac.

The problem is, the Developer tab is hidden by default. You can open the VBA Editor by clicking on the Visual Basic option under the Developer tab. Follow the below steps to unleash the Developer Tab. While pressing the shortcut, make sure the target Excel worksheet for which you want to add the VBA script is opened. If you are not a VBA macro user, you may not see this DEVELOPER tab in your excel. When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and. If you dont see it, heres how to enable it: Windows: Click the File menu and select Options. List Box is located under Developer Tab in Excel. Answer: To display the Developer tab, click on the Preferences under the Excel menu at the top of the screen. The steps in this article were performed on a MacBook Air in the High Sierra operating system. If the Developer tab is enabled, itll be in the menu bar at the top of Excel. 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.

How to view developer tab in excel