Excel 2011 for Mac like the other Office versions provides option to customise Ribbon. Listed below are the various Ribbon customisation that can be done in Excel 2011.
Click the Excel menu and select Preferences from the menu list. In the Excel Preferences window, navigate to Sharing and Privacy section and click Ribbon option.
Turn On/Off Ribbon
Navigate to General section and use the check box with caption as “Turn on the ribbon” to turn on/off the Office Ribbon in Excel 2011. If you want to increase the worksheet work area then you can turn off this option.
The “Expand ribbon when workbook opens” when checked would automatically display the Ribbon when you open the Workbook.
Hide group titles
Office Ribbon generally displays titles for each group. For example the Home tab consists of group titles like Edit, Font, Alignment, Number and Format. You can turn off these group titles by marking the check box with caption as “Hide group titles”.
Change the Ribbon Appearance
Use Appearance drop down under Customise section to change the Ribbon Appearance. The default Appearance for Excel 2011 is set to “Excel Green”
Hide or Change order of tabs
Excel 2011 users can also hide or change the display order of tabs in Office Ribbon using the Show or hide tabs list. Let say you are not going to use Review and Developer features then you can uncheck those tabs to hide them.
Similarly if you wan Formulas tab to appear next to Home tab then you can drag Formulas and place ahead of all the tabs.