How To Add Your Own Custom Tabs And Groups To The Ribbon

2017-01-25

Excel’s default ribbon menu organisation is for the most part pretty intuitive and contains most thing you need to use. But did you know that you can add your own custom tabs to the ribbon or add new groups to an existing tab? Not every tool is accessible from the default ribbon, so this can be very useful for easily accessing certain hidden commands or creating a frequently used commands menu.

 

 

Open Excel’s Options menu to customize the ribbon.

  1. Go to the File tab in the ribbon.
  2. Select Options from the menu. Alternatively, you can open the options menu by left clicking any empty area in the ribbon and selecting Customize the Ribbon.

 

 

We can add in our custom tab or group.

  1. Select Customize Ribbon.
  2. Press the New Tab button, this will also create a new group within the new tab. Alternatively, you can add a group to an existing tab by selecting the tab in the Main Tabs box then press the New Group button.
  3. Select your new tab and press the Rename button.
  4. Enter the display name for your new tab and press the OK button.
  5. Select your new group and press the Rename button.
  6. Enter the display name for your new group and press the OK button.
  7. Now you can add action items. Select any item you wish to add.
  8. Press the Add button to add them to your new group.
  9. Press the OK button.

 

 

Now you will see an extra tab in your ribbon with all the new groups of actions you added.

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

37 Awesome Excel Mouse Tips & Tricks You Should Know

37 Awesome Excel Mouse Tips & Tricks You Should Know

While the keyboard is generally quicker, you shouldn’t completely ignore the mouse. There are also some great time saving mouse shortcuts as well. In this post we’ll take a look at some of the best Excel mouse time saving tips and tricks.

read more
25 Amazing Power Query Tips and Tricks

25 Amazing Power Query Tips and Tricks

Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.

read more

Comments

0 Comments

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This