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. Customize the Ribbon

  6. 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
  7. Select the group you just created, which should be called New Group (Custom), and click Rename
  8. Rename a group

  9. Enter a name for your group and click Ok
  10. Your new group is created giving access to all the tools you need

    Newly created group on the Ribbon

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
  4. A new tab and group are created and named New Tab (Custom) and New Group (Custom) respectively

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

  8. Rename the group in the same way
  9. 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
  10. Add further groups to your tab as necessary. Add the required commands and don't forget to rename the groups
  11. Click Ok when finished
  12. New tab on the Ribbon

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. uncheck boxes to hide tabs

  5. Click Ok

Minimise the Ribbon

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

  • Click the Minimize the Ribbon button
  • Minimize button on the Ribbon

    Or

  • Press Ctrl + F1

Follow us on

Facebook  Twitter  You Tube