You can customize the Ribbon in Excel so that you add your own tabs and icons to run commonly used tasks and tools, or run your macros.
NOTE : This applies to Excel 2010 and 2013 only. Modifying the Ribbon in Excel 2007 is a different process which I will cover in another post.
Just follow the steps below, it should only take about 5 minutes.
You can also modify the Quick Access Toolbar to show your own icons for macros and commands.
Right click your mouse anywhere on the QAT or the Ribbon, and from the menu that appears, click on Customize the Ribbon...
The next window that appears has a list of commands on the left had side of the main pane, from this you can choose commands to add to the Ribbon.
You can uncheck the default tabs listed on the right hand side, but you can't remove them. You can open up the tabs and remove items in them though. For example, if you double click on Home to open it, you see the groups in the Home tab like Clipboard, Font, Alignment etc. These items can be removed.
Click the New Tab button to create a new tab. This will be added to the right hand side of the pane with the default name New tab (Custom), and a new group inside it named New Group (Custom).
Select the new tab and then you can either right click and choose Rename, or click on the Rename button.
Enter a new name for the tab and click OK. I'm calling mine PGT.
Select the new group and rename it as we just did with the tab. When you click on Rename you'll see this window.
Enter the new group name in the Display name box. Choosing an icon has no effect. My new group is called PGT's Macros.
OK so I've renamed my tab and group, now I need to add some commands or macros to it.
If you leave the Choose commands from drop-down as Popular Commands then you can add regular Excel commands, but I want to add some awesomely cool macros, so I'm choosing Macros from the drop-down.
This is what you want to choose if you want to add macros from your Personal.xlsb.
From the list of macros that are now displayed, click on the macro you want to add, then click on the Add>> button. I've added two macros.
As with the new tab and group, we now need to rename our macros to something more meaningful. Right click the macro and choose Rename.
You should now be looking at a large list of icons. Choose the icon you want for your macro. I'm going with a bright green square (I like green).
In the Display name box, enter a name for the macro, this also becomes the tool tip you see when you hover your mouse over the icon.
Repeat this process for each macro you added.
Once you have renamed all your macros you should have something like this.
You can adjust the position of the tab, group(s) and items in each group by first selecting the tab, group or item, and clicking the Up/Down arrows.
When you are finished with your changes, click OK to close this window and you'll see that you now have a new tab on the Ribbon with your new group and icons for the macros.
If you liked this or know someone who could use it please click the buttons below to share it with your friends on LinkedIn, Google+1, Facebook and Twitter.