Enable Developer Ribbon
Enable Developer Tab – The Easiest Way
May 4, 2019
What is a Macro – An Introduction to the macros in MS Word
May 27, 2019
Show all

Custom Tab in Office Ribbon – How to Create Your Own

It is very easy to Create a Custom Tab in Microsoft Office Ribbon — works with Microsoft Word, Microsoft Excel, and other office products. You can add your favorite command shortcuts and macro shortcuts to it.

You can also add shortcuts to existing tabs too.

In this example, we will create a Custom Tab in Microsoft Office Ribbon add a shortcut to a Macro, but you can use any of the functionalities like Save, Print, etc.

Create a New Tab and New Group

  1. Right-click anywhere on the Ribbon and select Customize the Ribbon. You will see the dialog seen earlier in the post where we talked about Enabling Developer Toolbar.
  2. In the dialog that appears, select New Tab to create a new Tab.
  3. In the same diablog, select the tab name in the right column that you just created, and this time click New Group to create a new group.
  4. Now click on the New Group and click Rename and type a name that you like.
  5. Custom Tab in Office Ribbon - Create New Tab
    Create New Tab
  6. Then select New Group and click Rename to rename the group. In this Rename dialog, you can even assign an icon for the group. This would be a good place to logically group functionalities. This is NOT the name of the macro.
  7. Custom Tab in Office Ribbon - Rename the Group
    Custom Tab in Office Ribbon – Rename the Group

    Adding Commands to the New Tab

  8. At the top of the left column, you would see a drop down with default value as Popular Command. Change it to Macro.
  9. Custom Tab in Office Ribbon - Add Commands to the new Tab
    Add Commands to the new Tab
  10. Important: Confirm that on the right column, your new newly created Group under your group is selected and click Add.
  11. Select the macro name on the right column and Rename it and select any Icon.
  12. Click OK to close the dialog

Congratulations! You just added a new Tab with a button that executes a macro. Wasn’t it easy to create a Custom Tab in Microsoft Office Ribbon?

How was your experience? Did you find it easy? Let us know in the comments section below.

Custom Tab in Office Ribbon Created
Custom Tab in Office Ribbon Created!

Leave a Reply

Your email address will not be published. Required fields are marked *