Set Developer Tab in Excel 2010 as Your Default Option

What is developer tab?

Developer tab is an extremely useful button in the excel worksheet and is often used by the developers all around the world. This tab is mostly used for various purposes and hence is categorized into five main categories. “Code” is a section under the developer tab that is used as launching pad of the Visual Basic Editor. You may also use it for recording Macros. The “Add-In tab” is yet another option under the developer tab and is used for installing certain add-ins such as Solver, COM, etc. The “Control button” falls under the third category of developer tab and is used to control the ActiveX controls of the worksheet. “XML” falls under the fourth category of developer tab and is highly used for XML coding in the spreadsheet. The last tab is the modify tab and it contains the document panel only.
Steps To Be Followed To Set the Developer Tab as Default Option

The excel 2010 spreadsheet doesn’t come with the developer tab as a default option. Instead, it is located in the backstage page of the excel 2010. You can bring the developer tab in the ribbon menu by following certain simple steps.

  • Open a new or existing spreadsheet in your computer.
  • Now, click on the “office button” located at the extreme left side of the spreadsheet.
  • A single click on that button will open up a series of options laid vertically on the page.
  • Now, select the “options” button on that sheet and click it once.
  • As soon as you do it, the dialogue box for Excel options will be displayed, here search and click the customized ribbon option.
  • Here, you may see the Developer option in the right sidebar.
  • Find it and click “OK” to bring the developer button on the ribbon menu in the spreadsheet.
  • Once you repeat all these steps you won’t need to reach the developer button through the “office button” anymore.

The developer button will flash at the end of the row towards right side of the page. The button appears next to the “view” button on the ribbon menu. This customized default setting of the button will help you to access the button and its associated tools at a quick click of a button.


If Developer Tab is not in the Ribbon..

  • Open Excel.
  • Go to VBA Editor (press Alt + F11)
  • Go to Immediate Window. ( Ctrl + G)
  • Write below Code.
    • Application.ShowDevTools = True

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.