See More About: , ,

How to Enable the Developer Tab in Excel 2010

by

Are you trying to create a macro in Excel 2010, but can’t find the macro button anywhere? Don’t worry it’s there, but the tab containing the macro button and others is disabled by default. Follow the instructions in the guide below so that you can enable the Developer tab in the Excel Ribbon so that you can start using macros, buttons, and other developer tools available in Excel 2010. If you have any comments or questions please use the comments form at the end of the article.

Software used: Excel 2010.

How to Enable the Developer Tab in Excel

1. Open Excel and click on File to open the menu.

2. Click Options from the list.

enable developer tab excel 2010 How to Enable the Developer Tab in Excel 2010

3. When the Excel Options window opens click on Customize Ribbon on the left pane.


4. In the Customize the Ribbon section you will notice a listing of the Main tabs. Add a checkmark to Developer to enable the tab.

5. Click OK to save the changes.

enable developer tab excel 2010 a How to Enable the Developer Tab in Excel 2010

A. When you click on the Developer tab you will have access to all of the developer tools in Excel 2010.

Originally posted Oct 19, 2010

We close comments after 30 days on GilsMethod.com and ask that you post questions and issues on our Answers website.

This helps us better serve you by allowing us to keep track of unanswered questions that are usually hidden in long comment threads.

Answers.GilsMethod.com is a community-powered support website where you will be able to post questions, and other users including us will respond with expert advice.

So if you are having trouble with your PC, Mac, iPad, iPhone, or other piece of technology, head over to Answers.GilsMethod.com and ask away.

  • Peligun

    I mean i cn’t get the ribbon thing in the options menu

    • http://www.gilsmethod.com Gilberto J Perera

      Can you please be more specific? Is the ribbon visible? Thanks.

      Regards,

      Gilberto J Perera
      Editor-in-Chief, GilsMethod.com

  • Peligun

    it doesnt work