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 –
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.
Step 3: Click Customize Ribbon from the list of tabs at the left side of the Excel Options window.
Step 4: Check the box to the left of Developer in the Main Tabs section at the right side of this window.
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 –
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.