See More About: , , , ,

How to Enable the Developer Tab in Excel 2011


If you are coming from Office for Windows to Office for Mac you will find a lot of differences, specifically when it comes to find tools you may frequently use. In my case I tend to use some of the developer tools to customize spreadsheets in Excel, but by default the Developer tab is disabled in Excel 2011. The guide below will show you how to enable the Developer tab in Excel 2011. If you have any comments or questions please use the comments form below.

Software/Hardware used: Excel 2011 running on Mac OS X Snow Leopard.


1. Open Excel and click Excel on the Menu bar. Click Preferences from the menu.

2. When the Excel Preferences window opens click Ribbon.


3. When the Ribbon page opens scroll down the Customize list and check Developer. Click OK to save the changes.


The Developer tab should now appear on the Office Ribbon. Click to open it and you are set.

If you have any comments or questions please use the comments form below.

Originally posted Jan 14, 2011

We close comments after 30 days on 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. 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 and ask away.

  • SgtExcel

    Thank you. This is exactly the information I needed. You rock!!!

  • Anonymous

    This is the first time i am hearing about 2011,..I hope this is the first blog to update about the ms excel-2011,..i think i have to give a try for this new one..
    villa in skopelos

    • Will,

      2011 is the latest version of Office specific to Mac, I hope I didn’t cause
      any confusion.