Excel > Excel 2010 Training Guide

Customise the Ribbon

Excel 2010 brings the ability to make customisations to the Ribbon. You can create your own tabs and groups on the Ribbon, and also customise the existing tabs and groups.

This new functionality now gives the ability to customise the interface to suit you, something that was really lacking in the release of Excel 2007.

Create a New Group on an Existing Tab

Add new groups to existing tabs on the Ribbon and include the tools you need.

1. Right click anywhere on the Ribbon
2. Click Customize the Ribbon
3. Select the tab you want to add the group to
4. Click the New Group button



5. In the Choose commands from list, select the commands you want to add to the group and click Add after each one. If you cannot see the command you want, click the drop list arrow next to Popular Commands and select All Commands
6. Select the group you just created, which should be called New Group (Custom), and click Rename



7. Enter a name for your group and click Ok

Your new group is created giving access to all the tools you need

Create a New Ribbon Tab

You can also create your own tab, and include the groups you want. This is the ultimate option allowing you to create your own all-in-one solution to fit your Excel needs.

Combine it with customising the Quick Access Toolbar and knowing some keyboard shortcuts and you shouldn't have to click on any other Ribbon tab again. All the other tabs can be hidden as described below.

1. Right click anywhere on the Ribbon
2. Click Customize the Ribbon
3. Click the New Tab button

A new tab and group are created and named New Tab (Custom) and New Group (Custom) respectively

4. Select the tab and click Rename
5. Enter a name for your tab and click Ok



6. Rename the group in the same way
7. Add the commands you want to the group using the Choose commands from list by selecting the command and clicking Add. If you cannot see the command you want, click the drop list arrow next to Popular Commands and select All Commands
8. Add further groups to your tab as necessary. Add the required commands and don't forget to rename the groups
9. Click Ok when finished

Hide Ribbon Tabs

Ribbon tabs that you do not use can be hidden to remove clutter from the screen.

1. Right click anywhere on the Ribbon
2. Click Customize the Ribbon
3. Uncheck the boxes next to the tabs you do not want shown



4. Click Ok

Minimise the Ribbon

The Ribbon can now be minimised at the click of a button.

• Click the Minimize the Ribbon button



Or

• Press Ctrl + F1

New Backstage View or File Tab

Suggestions and comments? Email us
© computergaga 2009
Privacy Policy