Not all Microsoft Excel users are comfortable working with the tabs preinstalled on the Ribbon. Sometimes it’s much more practical to create your own tab with the required set of commands. In this tutorial, we will show you how to do this in Excel.
Any Excel user can customize the Ribbon to suit their needs by creating the necessary tabs with any list of commands. Teams are placed in groups, and you can create any number of groups to customize the Ribbon. If desired, commands can be added directly to predefined tabs by first creating a custom group.
- Right-click on the Ribbon and select from the drop-down menu Customize the ribbon.
- In the dialog box that appears Excel options search and select Create tab.
- Make sure it’s highlighted A new group. Select a team and click Add. You can also drag commands directly into groups.
- After adding all the necessary commands, click OK. The tab is created and the commands are added to the Ribbon.
If you did not find the required command among the frequently used ones, open the drop-down list Select teams and select the item All teams.
