One of the things that I searched for and had a hard time finding in the Mac version of Excel was how to add the Developer tab to the Ribbon. The Developer tab is a handy way to launch the Visual Basic Editor, launch the Macro dialog box, quickly start recording a macro and access many of the other developer tools available. To add the Developer tab, select Excel from the menu. It is between the Apple logo and File in the upper left hand corner of the menu. From the drop down menu select Preferences. In the Sharing and Privacy section, select Ribbon.
No, it's a fair question and I agree with you that it's amazing but, according to what I've seen online, you can't do that in Excel 2008. As I mentioned in my previous post, it was enabled in Excel 2011.
In the middle of the Ribbon dialog box you will see a box listing Tab or Group title. Scroll through this list and find Developer. Check the box and click OK. You know have access to the Developer tab on the Ribbon. Hopefully this will help someone from countless, fruitless Internet searches that I had to do to discover this information.
See solution in other versions of Excel:. Question: In Microsoft Excel 2011 for Mac, how do I unhide a sheet that has been hidden? Answer: You can view all of the sheet names as tabs along the bottom of the document. To unhide a sheet, simply right-click on the name of any sheet and select Unhide from the popup menu.
When the Unhide window appears, select the sheet that you wish to unhide. In this example, we've selected Sheet1. Click on the OK button.
Now when you return to your spreadsheet, Sheet1 should be visible.