Search

How to create and add Custom Group in Excel Ribbon's Tab

 

To create and add a Custom Group inside Excel Ribbon's Tab, follow these steps.

Step 1 - Right-click anywhere on Excel Ribbon and then select "Customize the Ribbon", as shown in below image.

Open Excel Options Customize Ribbon Create Group

"Excel Options" window is opened and its "Customize Ribbon" Panel is displayed as shown below.

Excel Options Window Customize Ribbon Panel

Tip

"Excel Options" window to customize Excel Ribbon can be opened by following methods also.

• Click the "File" tab in Excel Ribbon and then click "Options". Select "Customize Ribbon" Panel.

Or

• Right-click anywhere on the "Quick Access Toolbar" (except on "Customize Quick Access Toolbar" drop-down button). Click "Customize Ribbon".

Step 2 - Select the Tab where you need to add a new Group. New Custom Group will be created and added in the selected Tab. Here in this case, I had selected "OmniSecuTab" Tab, which we had created in previous tutorial.

Click "New Group", as shown in below image.

Click New Group button to create new Custom Group

 

Step 3 - A new Custom Group is created inside "OmniSecuTab (Custom)" Tab, as shown in below image. The default name of new Group created is "New Group (Custom)".

New Custom Group created

 

Step 4 - To rename the newly created custom Group from its default name to any meaningful name, select the Group and then click "Rename" button as shown in below image.

Rename New Custom Group

Step 5 - Enter new name for Custom Group and then click "OK" button as shown in below image.

Enter new Tab name

Step 6 - Verify that the newly entered name for Custom Group is apperaing on right-side list in "Excel Options" window's "Customize Ribbon" panel. Even though the Group name is renamed, the word "(Custom)" continues to appear with the new Group name in the right-side list . The word "(Custom)" in your Group name helps to quickly identify between inbuilt Groups and user created Custom Groups.

Eventhough the Group is created and added to the Tab, it will not be visible untill commands are added to it.

Click "OK" button finish renaming the custom Group, as shown in below image.

Click OK to finish Custom Group Renaming

Click following links to learn

How to create and add a Custom Tab in Excel Ribbon

How to add a command button to Excel Ribbon's Group

 

 

Related Tutorials
• Excel Ribbon explained in detail
• Responsive Nature of Excel Ribbon
• Different types of Buttons in Excel Ribbon
• How to collapse Excel Ribbon
• How to Customize Excel Ribbon
• How to create and add a Custom Tab in Excel Ribbon
• How to add a Command button to Excel Ribbon's Group
• How to reset Excel Ribbon customizations
• How to Import/Export Excel Ribbon Customizations
• How to add a Macro to Excel Ribbon
• How to change default Macro button icon in Excel Ribbon
• How to change the position of Tab on Excel Ribbon
• How to change the position of Group on Excel Ribbon's Tab
• How to change the position of Command button in Excel Ribbon's Group
• What is Excel Ribbon Contextual Tab, Excel Ribbon Tool Tab
• Excel Formula Bar explained in detail
• Excel Status Bar in brief
• Excel Status Bar explained in detail
• Excel Quick Access Toolbar (QAT)
• Excel Backstage View
• Excel Options Dialog Box Window