Excel Anatomy - Create Your Own Ribbon

Create own ribbon

1. Right click on ribbon area and select “customize ribbon” option
2. Now, add a new tab (or group or both) – see below for illustration.
3. Add a few commands (or buttons) to your new ribbon 
4. Click ok and you have a sparkling new ribbon ready.

 

 

1. Use New Tab button to create a new ribbon tab.
2. Use New Group button to add a new group of commands to an existing or new ribbon.
3. Rename button helps you to change the name of an existing custom group or tab.
4. Once you add a group / tab, you have to select it to add items to that group / tab.
5. You can choose the type of commands you want to add to your ribbon tab / group. You can also add any macros as well (sweet!).
6. Now select the command you want to add to your group
7. Click on “Add” button to add the command to your ribbon tab / group.
8. You can use “Remove” button to remove any commands from custom tabs / groups.
9. Use the up / down arrow buttons to move your ribbon tab / group up or down. (For eg. you can move your custom tab to first, ie before home tab).

    A. You can export your ribbon customizations and re-use them in other computers (both ribbon and QAT settings will be exported).

        You can now add a group of commands (for eg. all alignment options) to Quick Access Toolbar to improve your productivity.