How to customize Office Ribbon in Excel 2011

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.


Expand Ribbon

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”


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.



In Category: Apple, Mac, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.