Today I'm going to write how to customize the Ribbon in Excell 2020.
There are lots of inbuilt options on the ribbon in Excel. If we need to add our own group to the ribbon, there is an option to customize the ribbon and to insert our own group into the ribbon.
First, you need to go to a free space of the ribbon and right-click on that space. Then you will appear as below.
After you need to click on the "Customize the Ribbon" option. Then bellow window will appear.
This window is the Excel Options window. You can be also found this window from below path.
- File → Options.
After you open this window you will be seen all the currently available tabs and tab groups are available here. In here you can not add any options to the existing groups. If you try to do that below message will appear.
Hence, If we need to create our own group you need to add a new group. In here I would like to add a tab to ribbon and after will add groups to that ribbon.
To do this, just right-click on the existing tab and click on the "Add New Tab" option.
The result will be as below.
Then you can rename the new tab with a new name. I will change this as "My Tab"
Now the tab archive will be shown as below with your tab and then click "Ok".
The new ribbon of your Excel will be shown as below. "My Tab" is there.
Ok. After that, we have to add tab groups into this tab. I will write it in the next post. Till then try this out.
No comments:
Post a Comment