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.

201307291030.jpg

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.

201307291032.jpg

Expand Ribbon

The “Expand ribbon when workbook opens” when checked would automatically display the Ribbon when you open the Workbook.

201307291039.jpg

Hide group titles

201307291043.jpg

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

201307291046.jpg

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”

201307291049.jpg

Excel Green

201307291050.jpg

Graphite

201307291051.jpg

Hide or Change order of tabs

201307291053.jpg

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.

201307291056.jpg

Similarly if you wan Formulas tab to appear next to Home tab then you can drag Formulas and place ahead of all the tabs.

201307291057.jpg

201307291059.jpg

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.