There are eight default tabs on the Excel 2011 Ribbon, and nine if you unhide the Developer tab. They are Home, Layout, Tables, Charts, SmartArt, Formulas, Data, Review, and Developer.
Comparing the Excel 2010 Ribbon, the new Windows version, where the tabs are Home, Insert, Page Layout, Formulas, Data, Review, View, and Developer.
The Tables, Charts and SmartArt tabs in Excel 2011 are new and different from Excel 2010, and seem to replace its Insert tab. The Layout tab is similar to Page Layout. The rest of the tabs have the same names in both versions, yet are slightly different, as shown below in Home Tab Comparison.
In Excel 2011 the Menu and Standard Toolbar are still visible above the ribbon. This accounts for some of the variation in Ribbons between the two Excel versions. But then Excel 2010 has the Quick Access Toolbar.
Below are a few Ribbon screen shots. (Click to enlarge the image in a new window for better visibility)
Home Tab Comparison
As you can see below the Menu and Standard Toolbar are still present above the Ribbon in Excel 2011 (Workbook2). What’s curious is that you can also make the Formatting Toolbar visible, which is completely redundant with the Home tab in Excel 2011.
The bottom of this picture shows the Excel 2010 Ribbon Home tab.
The grouping labels are located above the toolbar items in Excel 2011 and below the items in Excel 2010. I like them above. For Excel 2011 they are Edit, Font, Alignment, Number, Format, Cells, and Themes. For Excel 2010 they are Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.
Just be glad you’re not switching between these two versions of Excel like me.
Now here’s a quick look at the different Excel 2011 Ribbon tabs. Remember to click each image to enlarge for better viewing.