#How to show the developer tab in excel how to#
The tab is turned off by default in Microsoft Office, but you can learn how to set it up in a breeze. Step 2: Click the Excel tab at the top of the screen, then choose the Preferences option. The best way to access the VBA developer environment, is the so-called Developer tab. You can find the Developer tab next to the View tab. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary). This article will show you how to add the Developer tab in the Windows version of Excel. Right click anywhere on the ribbon, and then click Customize the Ribbon. Are you trying to follow a tutorial or guide online that is telling you to select an option on the Developer tab in Excel 2013 If so, then you may have noticed that you don’t have a Developer tab. 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. How to Add the Developer Tab to the Ribbon in Excel 2016 for Mac Now, you can find the ‘Developer’ option under ‘Main Tabs’, and you can tick or check the box beside it. First, click on the File button on the top left-hand corner of the screen and then click on the Options. 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. How to Add the Developer Tab in the Excel Ribbon Step 1. Click on the Check Box icon under the Form Controls section. In the Form Controls section of the drop-down menu, click on the Checkbox icon. Select the Insert button inside the Controls group of the Developer tab. 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. To insert a checkbox in Excel, follow these steps: Go to the Developer tab and click on the Insert button inside the Controls group.