RIBBON IS THE AREA AT THE TOP OF THE MS OFFICE TOOLS SUCH AS EXCEL, WORD, POWERPOINT ETC. WHICH CONTAINS ALL THE CONTROL BUTTONS CLASSIFIED INTO TABS AND GROUPS.
RIBBON is located on the top of the working area [ cells or sheet ]. The reference picture is shown in the previous section.
The ribbon has a standard format when we have a newly installed MICROSOFT EXCEL in our system. But we can customize the ribbon easily.
We can add , customize or remove any command or tab from the ribbon as per our choice.
Let us learn to Show or Hide any Tab from the ribbon.
Follow the steps to SHOW OR HIDE a tab from the ribbon in Microsoft Excel.
If we want to add the commands, follow the steps.
After choosing the option CUSTOMIZE THE RIBBON either by RIGHT CLICKING the RIBBON or through the FILE MENU, following option opens up.
Have a look at the picture below.
EXCEL OPTIONS has the selection for the CUSTOMIZE RIBBON which is a completely separate option available.
The option consists of two lists.
The left list contains all the commands available and the right list contains the Present Layout and the selected options for the Ribbon.
SHOW ANY TAB ON THE RIBBON:
HIDE ANY TAB ON THE RIBBON:
If we have a created a new functionality like a Macro or Function etc. , it would be great if we could find these options in the Tab itself.
EXCEL gives us the option of creating our own TAB and putting any additional commands or the custom commands in the Tab.
If we want to change the order of the commands, follow the steps.
In the picture above, we have selected the DRAW TAB, so the new tab is inserted just below the DRAW TAB. Refer to picture below.
After the NEW TAB has appeared in the MAIN TABS , its time now to change the name of the Tab as per your choice.
After Renaming the NEW CUSTOM TAB, the situation is something like this.
We have a new empty TAB named GYANKOSH.NET.
Now, let us change the GROUP NAME also.
Till now we have already created a new CUSTOM TAB in RIBBON of MICROSOFT EXCEL and a group named gyankosh.net.
Now, let us add some functions to this tab so that we can save our time by directly using these functions.
REFER TO THE PICTURE GIVEN BELOW.
On the left hand side, there is a long list of AVAILABLE OPTIONS which can be put in our custom tab.
At the top there is a drop down [ mentioned in the picture too ] from which we can select the group of the commands available as per choice. For example
COMMANDS NOT IN THE RIBBON , MACROS, ETC.
If you want to select from the complete exhaustive list of the options, go for ALL COMMANDS.
After you have selected and Added all the commands you want, Click OK at the bottom and we are done.
For our example, we have taken three commands namely CALCULATE NOW, BORDERS, CENTER.
The following picture shows the NEW CUSTOM TAB which contains the commands as per our choice.
Suppose , we have created a lot of changes and we want to RESET all the customization of the RIBBON. [ Resetting is the process of bringing the custom things back to the original state].
If we want to reset the RIBBON CUSTOMIZATIONS , follow the steps.
RIGHT CLICK the RIBBON and choose CUSTOMIZE THE RIBBON option or reach through the FILE MENU> EXCEL OPTIONS > CUSTOMIZE RIBBON.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE