Search

How to change the position of Tab on Excel Ribbon

You can change the position of Tabs in Excel Ribbon, to a position comfortable to your working style. To change the position of Tabs in Excel Ribbon, 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 Tab position

 

"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 - The top-most Tab in right-side list corresponds to the left-most Tab in Excel Ribbon . Refer below image.

Tab Position in Excel Ribbon.jpg

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

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

For example;

If you need to change the position of "OmniSecuTab (Custom)" to the first position, select "OmniSecuTab (Custom)" and use "Move Up" arrow to bring it to top, as shown in below example. After changing the position, click "OK" button.

Move Up arrow to move the Tab to left of Ribbon

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

Move Up arrow  clicked to move the Group to left of Ribbon

You can see from below image that the position of "OmniSecuTab (Custom)" has changed to left in actual Excel Ribbon.

Tab position changed to left in Excel Ribbon

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

Click below links to learn

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

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