"Customize Excel 2010 Ribbon - Adding New Tab, Group and Command"

How to customize Excel 2010 ribbon to suit your needs?

The default Excel Ribbon contains eight tabs, and each of those tabs contains lots of commands in the form of buttons, galleries, lists, and other controls. Well, you can improve your Excel productivity by customizing the Excel 2010 Ribbon with extra commands that you use frequently.

Most features in Excel 2010 are available through the commands on the Ribbon tabs. Beside the default commands, Excel 2010 has many other commands available that you may wish to add one or more of these other commands if you use any of them frequently.

To add a new command to the Ribbon, you must first create a new tab or a new group within an existing tab, and then add the command to the new tab or group.

To display the customize ribbon tab

  • Right-click any part of the Ribbon and click Customize the Ribbon.
  • Excel 2010 customize the ribbon

  • This will display the Excel Options dialog box with Customize Ribbon tab selected.

To add a new Group or Tab

  • From the Excel Options dialog box with Customize Ribbon tab selected displayed, click the tab you want to customize under the Main Tabs in the Customize the Ribbon section. For example, click on the Home.
  • Click New Group button. Excel adds an entry called New Group (Custom).
  • Excel 2010 add new group

  • Click Rename button. This will display the Rename dialog box.
  • Excel 2010 rename group

  • Type a new name for the group in the Display name: section (for example, type Test). You can also select a symbol that represents the group.
  • Click OK.

Note: You can also click New Tab button to create a custom tab.

To add a command to the Group

  • From the Excel Options dialog box with Customize Ribbon tab selected displayed, click the Choose commands from drop down menu, choose the command category you want to use. For example, choose Commands Not in the Ribbon.
  • Then, it will display the whole list of commands. Click the command you want to add (for example, select Bullets and NumberingÂ…).
  • Click the custom group or tab you want to use. For example, click on the Test group that we just created.
  • Click Add >> button. Excel adds the Bullets and Numbering command to the Test group.
  • Excel 2010 add command

  • To remove the added command, click on it and then click << Remove button.
  • Click OK.
  • Excel adds the new group and command to the Ribbon.

Related Topics:

Getting Started with Microsoft Excel 2010

Knowing the Excel 2010 Screen Elements

Understanding the Excel 2010 Ribbon

Adding and Removing Commands From The Quick Access Toolbar

Guide to Customize the Quick Access Toolbar in Excel 2010

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Customize Excel 2010 ribbon info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb

Google Search:

Custom Search

Recommended Resources:

Click on the image to view the details of the training/book.
Excel 2010 formulas ebook
Microsoft Excel 2010 Formulas

Excel 2007 ebook
The Ultimate Guide to
Excel 2007!

PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007

What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.