Search

How to change the position of Group on Excel Ribbon's Tab

In this tutorial we have two custom groups in Excel Ribbon's custom Tab "OmniSecuTab". The Tab Groups are named as "OmniSecuGroup 1" and "OmniSecuGroup 2", as shown in below image.

Excel Window Change Ribbon Group position

If you want to change the position of 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 Change Ribbon Group position

 

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".

"Excel Options" window is opened and its "Customize Ribbon" Panel is displayed as shown below. Excel Ribbon's custom Tab "OmniSecuTab" and Groups "OmniSecuGroup 1" and "OmniSecuGroup 2" are marked inside right-side list.

Excel Options Window Customize Ribbon Panel

Step 2 - The top-most Group inside its parent Tab in right-side list corresponds to the left-most Group in actual Excel Ribbon's Tab. Refer below image.

Group Position in Excel Ribbon Tab

Moving a Group up in right-side list will result in moving the Group to left in actual Excel Ribbon. Moving a Group Down in right-side list will result in moving the Group to right in actual Excel Ribbon.

To change the position of a Group in Excel Ribbon's Tab, select the Group in right-side list. After selecting the Group in right-side list, click "Move Down" or "Move Up" (according to your requirement) Arrow to change its position.

For example;

If you need to change the position of Group "OmniSecuGroup 2 (Custom)" to the first position inside its parent Tab, select "OmniSecuGroup 2 (Custom)" and use "Move Up" arrow to bring it to top, as shown in below example.

Move Up arrow to move the Group to left of Ribbon

Position of the Group in right-side list changed to top inside its parent Tab, as you can see from below image.

Move Up arrow to move the Group to left of Ribbon

 

You can see from below image that the position of "OmniSecuGroup 2 (Custom)" has changed to left inside actual Excel Ribbon's Tab.

Group position changed to left in Excel Ribbon

Similarly, you can change the position of a Group in Excel Ribbon's Tab to the right side using "Move Down" arrow.

Click below links to learn

How to change the position of Tabs on Excel Ribbon

How to change the position of command button in 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 create and add Custom Group in Excel Ribbon's Tab
• 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 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