Excel 2010 - Customized Ribbon / Tab

In Excel 2010, you can customize your own ribbon (i.e. Tab) and put your frequently use commands in it. With this customised Tab, you will not have to move from one tab to another to find those commands. The changes is likely to increase the current speed when working with Excel. In my verion of Excel 2010, I have a tab called Jason, which is meant to show all the commands I use frequently. See picture below:

To customised the Tab, follow the steps below:

1. Point your cursor at the Menu bar and right click.
2. In the pop-up menu, select Customized Ribbon.






3. In the next window, click on the button 'New Tab" found at the bottom of the window.
4. Rename the Tab to a name of your choice.
5. Rename a new group.






6. In the left hand window, select All commands and find the commands you use frequently, select the your new group and click Add. The commands i.e. functions will be added into the group.






7. Repeat the last step to add in more commands into your personalised Tab.
8. When completed, click OK and you will see your customized Tab appearing in the menu bar.

Customised Toolbar

Another change you can do with Excel 2010 and 2007 is the quick access toolbar. By placing the toolbar below the Tab instead of above, you are likely to click on the quick access toolbar more often. If you are an hard core Excel 2003 fan but is forced to use the new version of Excel 2007 and 2010, this will help you in your transistion. To move the quick access toolbar below the Tab, just click on the inverted triangle next to the quick acces toolbar and select "Show Below Ribbon". That's it.

•

New! Comments

Have your say about what you just read! Leave me a comment in the box below.