How to Show the Developer Tab in Excel 2013

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. 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.

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.


How to Display the Developer Tab in Excel 2013

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. 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.

Step 1: Open Excel 2013.


Step 2: Click the File tab at the top-left corner of the window.

click the file tab



Step 3: Click the Options button at the bottom of the column on the left side of the window.

click options at the left side of the window



Step 4: Click the Customize Ribbon option in the column at the left side of Excel Options.

click the customize ribbon option



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.

how to show the developer tab in excel 2013



You should now see the Developer tab at the top of the ribbon. If you click on it you will see all of the options that are available on this tab, which is shown below.

the excel 2013 developer tab



Are 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.