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

• 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).

• Click Rename button. This will display the Rename dialog box.

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



• 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: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb