Switching to the Mac platform finds you with certain disappointments challenges. One of these is finding no Insert Tab on the Excel 2011 Ribbon.
Windows versions of Excel (2007 and 2010) both have the Insert Tab on the Ribbon. So when you start using the new Mac version of Excel 2011, you can quickly become confused at the whereabouts of some familiar controls.
Excel 2011 has a Charts tab on the Ribbon that doesn’t exist in the Windows versions (2007, 2010). This is where the Charts and Sparklines Groups on the Insert tab are located.
Excel 2011 reminds me of a hybird version because while there’s a Ribbon, they left the old Menu bar at the top. This is reminiscent of Excel 2003 (Windows) with familiar menus for File, Edit, View, Insert, Format, Tools, Data, Window, and Help.
Generally speaking, the Insert menu in Excel 2011 holds most of the items in the Illustrations, Links, Text, and Symbols groups from the Excel 2010 Insert tab.
Are referring to Sheet Tabs?: Or are referring how to access (open Files) from within Excel Mac? To open files with Mac: Click on File menu; OR for sheet tab at lower left.: Click Bar next to the Bottom Slider, pull to right.
A Table to Help
I put together a table of each item on the Excel 2010 Insert tab, and it’s location in Excel 2011.
In the table below the two left columns show the Group and Item on the Excel 2010 Insert tab. The column on the right either shows the Ribbon location or the Menu location.
- Data > Analysis > PivotTable is an item location on the Ribbon.
- Insert – Photo – Picture from File… is an item location in the old Menu system.
You’ll also notice a few items that don’t exist (to my knowledge).
A quick alternative to some of these items in Excel 2011 is the Media Browser icon on the Toolbar, which gives you access to Photos, Audio, Movies, Clip Art, Symbols, and Shapes to insert into the worksheet.
Since you may want to refer to this table a little more closely here’s a PDF file to download.
Related posts:
This Excel tutorial explains how to display the developer tab in the toolbar in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, how do I get the Developer tab to display in the toolbar at the top of the screen?
The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.
Answer: To display the Developer tab, click on the Preferences under the Excel menu at the top of the screen.
When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section.
![Where are tabs in excel for mac mac Where are tabs in excel for mac mac](/uploads/1/2/5/8/125872054/875292643.gif)
In the Customize section, check Developer in the list of tabs to show. Then click on the OK button.
Now you should see the Developer tab in the toolbar at the top of the screen. All of the Developer tab option groups should be available - Visual Basic, Add-Ins, and Form Controls (see below).