Developer tab is one of the most important and highly useful options in Excel. But, before you use it you need add it on ribbon. When you install Excel, you need to activate it for first time.
- How To Open Excel File
- How To Open Options In Excel Mac
- How To Open Options In Excel Macros
- How To Open Microsoft Excel
So today in this post, you will learn 3 different methods to add developer tab in Excel for windows as well as in Excel 2011 for mac.
Quick Navigation
I just accidentally discovered that you can zoom in Excel via keyboard and mouse. If you hold down both the Control and Option keys, and then scroll using the mouse (for me it is two fingers on the MacBook Pro's track pad), you'll change the zoom level on the Excel sheet. I tried the same on Word but it does not work. Open Excel Options from Excel 2010/2013/2016/2019 Ribbon if you do not have Classic Menu for Office Click the File tab jumping into backstage view; Then you will view the Options button at left bar. Click it into Excel Options window. Learn the basics of using Microsoft Excel for Mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier.
To enable it follow these simple steps.
- Go to File Tab β Options β Customize Ribbon.
- In the main tab list, tick mark check box for the developer.
- Click OK.
![Opening Opening](https://1.bp.blogspot.com/-O-5rRtFrbSg/Wh8hFAEuoPI/AAAAAAAAOWg/_GpL2lfee-Yyd0ioEl9lZ1bB3H22bi5kwCEwYBhgL/s1600/excel%2B2016%2Bpreferences%2Bmac.png)
Here is another method to display developer tab.
- Right click on Excel ribbon and select customize ribbon.
How To Open Excel File
- In main tab list, tick mark check box for the developer.
- Click OK.
After following any of the above methods you can activate developer tab in Excel for Windows.
Note: You can use both of the above methods in Windows version of Excel (2007, 2010, 2013 and 2016)
![How To Open Options In Excel Mac How To Open Options In Excel Mac](https://www.excelcampus.com/wp-content/uploads/2014/08/Find-Excel-Add-in-File.png)
Here are the steps to add developer tab in Excel 2011 for Mac.
- Go to Excel Menu β Preferences.
How To Open Options In Excel Mac
- Click on Ribbon in 'Sharing & Privacy Group' and then Click OK.
- Now, you will get a pop-up dialog box. In customization section, select Developer Tab & click OK.
After following any of the above methods you can activate developer tab in Excel 2011 for Mac.
What's Next
VBA is one of the Advanced Excel Skills, and if you are getting started with VBA, make sure to check out there (What is VBA and Excel Programming)
How To Open Options In Excel Macros
How To Open Microsoft Excel
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ο¬nd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.