How to Change Excel Sheet from Right to Left (4 Suitable Ways)

This article illustrates how to change the excel sheet direction from right to left. The Excel sheet direction is from left to right by default. You can change the sheet direction to Right-to-Left if required. But if you have accidentally changed the sheet direction then follow the article. You will learn about a number of ways to change the sheet direction back from right to left.


4 Ways to Change Excel Sheet from Right to Left

The Excel sheet direction is from left to right by default. It shows the row numbers and sheet tabs on the left. The column numbers also start from the left.

If you accidentally changed the sheet direction, it will look as follows. Here the row numbers and sheet tabs are on the right. The column numbers also start from the right.

  • Follow the methods below to change it back from right to left.

1. Excel Sheet from Right to Left by Enabling from Excel Options

You can change the sheet direction using Excel Options. Follow the steps below to be able to do that.

📌 Steps:

  • First, press Alt + F + T to open the Excel Options. Then select the Advanced tab. After that, go to the Display options for this worksheet section. Next, uncheck the Show sheet right-to-left checkbox. Finally, click on the OK button.

change excel sheet from right to left

  • This may not work for new workbooks if the default sheet direction is set to Right-to-left. Go to the display section to fix that. Then mark the radio button for Left-to-right to reset the Default Direction. Click OK after that.

change excel sheet from right to left

Read More: How to Flip Excel Sheet from Left to Right (4 Easy Ways)


2. Add Right-to-Left Document Command to Quick Access Toolbar

If you often need to change your sheet direction, you can add the Right-to-Left Document command to the Quick Access Toolbar. Follow the steps below to be able to do that.

📌 Steps:

  • First, click on the Quick Access Toolbar Menu as shown below. Then select More Commands. This will take you to the Quick Access Toolbar tab on the Excel Options window.

  • Alternatively, you can use the Alt + F + T shortcut to do that. Then choose All Commands from the dropdown list. Next, scroll down and select Right-to-Left Document. After that, click on the Add button.

change excel sheet from right to left

  • Finally, the command will be available in the Quick Access Toolbar. Now you can change the sheet direction with a single click.

change excel sheet from right to left

Read More: How to Flip Rows in Excel (4 Simple Methods)


Similar Readings


3. Customize Ribbon to Add Right-to-Left Document

Alternatively, you can customize the Ribbon to add that command.

📌 Steps:

  • You can see the command included in the Sheet Options group in the Page Layout tab from Excel Options.

  • Yet, it is not visible in the Ribbon.

  • Now follow the steps to make it visible in the Page Layout tab.
  • First, go to Excel Options using the Alt + F + T shortcut. You can also select File >> Options to do that.
  • Then select the Customize Ribbon tab. Next, expand the Page Layout tab. After that, select the Sheet Options group. Now click on the New Group button below. Then a custom group will be created. Select it and click on Rename.

  • Next, type a name and click OK.

  • After that, choose All Commands using the dropdown. Then, select the Right-to-Left Document command and then click on the Add button. Finally, select OK.

change excel sheet from right to left

  • After that, you can access the command from the Page Layout tab.

change excel sheet from right to left

Read More: How to Flip Data Horizontally in Excel (3 Effective Methods)


4. Change Excel Sheet from Right to Left Using Group Policy Editor

You can also use the Group Policy Editor to change the excel sheet direction from right to left. Follow the steps below to be able to do that.

📌 Steps:

  • First, type gpedit.msc on your windows search bar and press ENTER.
  • Then go to the following path: User Configuration >> Administrative Templates >> Microsoft Excel >> Excel Options >> Advanced.
  • Next, double-click on the Default sheet direction setting.

  • After that, mark the radio button for Enabled. Then change the default sheet direction from Right-to-Left to Left-to-Right.
  • Finally, select Apply and then OK.

change excel sheet from right to left

Read More: How to Flip Columns and Rows in Excel (2 Easy Methods)


Conclusion

Now you know how to change the excel sheet direction from right to left. Which method did you prefer? Do you have any further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo