Show the Developer tab

Excel 2016 2013 2007
You should display the Developer tab when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs. Do the following:

   1.   To open the Excel Options dialog box, do one of the following:

  • On the File tab, click the Options button:
    Excel 2010 Options
  • Right-click in any tab (ribbon) and choose Customize the Ribbon... in the popup menu:
    Excel 2010 tab popup menu

   2.   In the Excel Options dialog box, on the Customize Ribbon tab, in the left column, check the Developer tab:

Customize Ribbon in Excel 2010

   3.   Click OK.

For more details, see Creating Your Own Menu.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.