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.
"Excel Options" window is opened and its "Customize Ribbon" Panel is displayed as shown below.
"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.
• 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.
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)".
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.
Step 5 - Enter new name for Custom Group and then click "OK" button as shown in below image.
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 following links to learn