How to Show the Developer Tab in Excel 2010

Microsoft Excel 2010 uses a unique navigational structure via the various tabs displayed at the top of the window. Each tab contains a number of different tools and options that you can use to customize the look and behavior of the data you have entered into your spreadsheets. While there are a huge number of options available in these assorted tabs, there are even more things you can do by adding the Developer tab to the top of the window. Many tutorials you find online for advanced Excel tasks will involve this tab, so it is important to know how to display it.


Excel 2010 Developer Menu

The default tab configuration in Microsoft Excel 2010 looks like this –

default excel 2010 tab layout


Depending upon the other programs you have installed on your computer, such as certain Adobe or accounting programs, you might have some other tabs as well. But the Developer tab is not there in a default installation. So continue reading below to learn the simple method for displaying the Developer tab and gaining access to the assorted tools it contains.


Step 1: Launch Excel 2010.

Step 2: Click the File tab at the top-left corner of the window, then click Options at the bottom of the column on the left.

click file, then click options in excel


Step 3: Click Customize Ribbon from the list of tabs at the left side of the Excel Options window.

open the customize ribbon menu in excel 2010


Step 4: Check the box to the left of Developer in the Main Tabs section at the right side of this window.

how to show the developer tab in excel 2010


Step 5: Click the OK button at the bottom of the window to apply your changes.


You will now have a Developer tab at the top of your screen like this –

the excel 2010 tab layout with developer


This new tab provides you access to many new options and tools that will expand the functionality of your Excel installation.


Have you experienced problems with the behavior of hyperlinks in your Excel spreadsheets? Learn how to disable the automatic hyperlink setting in Excel 2010 to be able to insert URLs and file locations without having Excel turn them into clickable hyperlinks. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.