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

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 qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos 😃

John MacDougall

I’m John, and my goal is to help you Excel!

You’ll find a ton of awesome tips, tricks, tutorials, and templates here to help you save time and effort in your work.

Related Posts

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 Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃