Create Custom Ribbon
We have been over customizing ribbons in a previous post. Now let’s see how we can create custom ribbon in Excel.
Starting with Excel 2007, Excel received a new interface with tabbed menus which is called ribbon. All the tools you can use are accessible through this ribbon. But it comes with the most used ones as default. Therefore you need to add/remove some of the tools based on your preferences.
Excel is quite flexible on this feature. It even lets you create custom ribbon so that you can arrange your tools to maximum fit your needs. Here is how to do it:
The fastest way to reach Customize Ribbon menu is to right-click on an empty space on any ribbon and select Customize the Ribbon. You can also reach same menu from FILE->Options->Customize Ribbon.
Customize Ribbon interface has two windows. Left window lists the tools available and right window lists the tabs. You can add and remove tools into tabs using the buttons between these two windows.
You can also create a new ribbon using the “New Tab” button located under the right window.
Doing this will add a new ribbon into your Excel interface. Let’s add a new ribbon and name it Beatexcel. You can rename your tab using the Rename button located right side of New Tab button.
Your new tab will be added into your menu ribbon with an empty new group. You can also change placement of your custom tab using the buttons located right side of the right window.
In order to populate your tab with tools, you need to use Customize Ribbon menu from options.
Make sure that your new group under your new tab is highlighted in right window
and then you can add tools into your new group by highlighting them and pressing Add button from between windows.
As the result of this action, your selection of tools will be added to your new toolbar.
If your new tool shows up as inactive on your ribbon, save the workbook and it will become active.