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.
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.