#Display developer tab in excel how to#

In the Excel Options dialog box, on the Customize Ribbon tab, in the left column, check the Developer tab: 3. display developer tab excel in office 365 for business. In the popped out Excel Options dialog, click Customize Ribbon in left pane. Click File > Options to open the Excel Options dialog. If you click on it you will see all of the options that are available on this tab, which is shown below.Īre you having trouble getting a spreadsheet to print how you want? Checkout our printing guide for some tips and settings that can help you make Excel printing a much less frustrating task. To open the Excel Options dialog box, do one of the following: Right-click in any tab (ribbon) and choose Customize the Ribbon. To show the Developer tab in Excel 2010 and later versions, please do as follow steps: 1. You should now see the Developer tab at the top of the ribbon. Step 5: Check the box to the left of Developer in the column at the right side of the window, then click the OK button at the bottom of the window. Step 4: Click the Customize Ribbon option in the column at the left side of Excel Options. Step 3: Click the Options button at the bottom of the column on the left side of the window. Step 2: Click the File tab at the top-left corner of the window. This is helpful when you need to use certain features of Excel, like Macros, that aren’t present on any of the other default tabs in Excel. The steps in this guide will show you where to find the option that will add the developer tab to the ribbon in Excel 2013. When the Excel Options window appears, click on the Customize Ribbon option on the left.

#Display developer tab in excel how to#

How to Display the Developer Tab in Excel 2013 Answer: To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu. Use an Excel macro to display the Sheet Navigation. In the list box on the right, place a checkmark next to Developer. Select Customize the Ribbon from the shortcut menu.

Customize the Ribbon tab of the Excel Options dialog box appears.

Our tutorial below will show you how to find and enable this setting so that you can show the Developer tab in your ribbon and gain access to the tools that it contains. To navigate to a specific drawing in Excel - Home tab > Find & select > Selection Pane. To display this tab, follow these steps: Right-click any Ribbon control and select Customize the Ribbon from the shortcut menu. Step 1: First, click on the File button on the top left-hand corner of the screen and then click on the Options button on the bottom left-hand corner of the screen. To activate the Developer tab in Excel, follow the below-mentioned steps. This happens because the Developer tab is not enabled by default, so you need to change a setting on the Excel Options menu to get it to appear. The developer tab in excel will not be visible unless you activate it from the options menu. 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 there, which can make completing that task a little difficult.