In an Excel sheet, the dataset usually shows from left to right. However, sometimes, the direction of the sheet is shown from right to left. This issue can be fixed in a very short time. In this article, we are going to demonstrate four quick ways to flip the Excel sheet from left to right. If you are curious about it, download our practice workbook and follow us.
How to Flip Excel Sheet from Left to Right: 4 Quick Methods
Currently, our Excel worksheet shows us the datasheet in the direction of right to left. In our four approaches, we will demonstrate the procedure to flip the direction of the Excel sheet from left to right.
1. Changing Default Direction
In the first method, we are going to modify the Default direction option of the Excel sheet to flip it from left to right. The steps of this procedure are given below:
📌 Steps:
- First of all, select File > Options.
- As a result, a dialog box called the Excel Options will appear.
- Now, choose the Advanced option.
- Scroll down with your mouse to get to the Display section.
- Then, change the Default direction option from Right-to-left to Left-to-right.
- Finally, click OK.
- You may notice that the direction of our current sheet doesn’t change.
- Again, click on File.
- After that, select the Blank Workbook option.
- A new workbook will appear.
- You will see that the direction of this workbook is changed, and it is flipped.
Thus, we can say that our method worked perfectly, and we were able to flip the Excel sheet from left to right.
💬 Things You Should Know
Only changing the Default direction of the sheet from the Display section will not flip the active sheet direction. It will show the new direction when you open a new workbook.
2. Changing Display Options for Worksheet
In this process, we are going to modify the options of Display options for this worksheet section. The steps of this approach are given as follows:
📌 Steps:
- First, select File > Options.
- As a result, a dialog box called the Excel Options will appear.
- After that, choose the Advanced option.
- Now, scroll down with your mouse to get the Display options for this worksheet section.
- You may notice that the Show sheet right-to-left option is showing checked.
- Then, uncheck the Show sheet right-to-left option.
- Finally, click OK.
- You will notice that within a second, the direction of your active sheet will flip.
So, we can say that our process worked effectively, and we were able to flip the Excel sheet from left to right.
3. Customizing Ribbon
In the following approach, we will customize our built-in Excel ribbon and add a new command to flip the Excel sheet from left to right. The procedure of this method is described below step-by-step:
📌 Steps:
- At first, select File > Options.
- A new dialog box called Excel Options will appear on your device.
- Now, select the Customize Ribbon option.
- The window titled Customize the Ribbon will show up.
- We want to add the command inside the Page Layout tab.
- So, select the Page Layout tab.
- Then, choose the New Group option.
- As a result, a new tab will create inside the Page Layout tab. If you want, you can rename this group by clicking on the Rename option.
- In this example, we set the group name as Flip.
- After that, change the Choose commands from field option from Popular Commands to All Commands.
- All available Excel commands will show up below.
- Now, scroll down with your mouse to get the Right-to-Left Document command.
- Afterward, select the command and click Add.
- You will see the command assigned in our new group.
- Next, place the Flip group at the top of all groups in this tab to find it easily.
- Finally, click OK.
- You will see the Flip group inside the Page Layout tab.
- Now, in the Page Layout tab, select the Sheet Right-to-Left command from the Flip group.
- You will see the sheet will flip in the direction of the left to the right.
Hence, we can say that our process worked precisely, and we were able to flip the Excel sheet from left to right.
4. Customizing Quick Access Toolbar
In the following procedure, we are going to customize our Quick Access Toolbar to flip the direction from left to right. The steps of this method are given below:
📌 Steps:
- Firstly, select File > Options.
- As a result, a new dialog box called Excel Options will appear in front of you.
- Now, select the Quick Access Toolbar option.
- The Customize the Quick Access Toolbar window will show up.
- Then, change the Choose commands from field option from Popular Commands to All Commands.
- All available Excel commands will show up below.
- After that, scroll down with your mouse to get the Right-to-Left Document command.
- Next, select the command and click Add.
- Afterward, check the Show Quick Access Toolbar option.
- Moreover, you can choose the location of placing the toolbar. Here, we choose the Below Ribbon option.
- Finally, click OK.
- You will get the Quick Access Toolbar below the Excel ribbon with the Sheet Right-to-Left command.
- Now, click on the Sheet Right-to-Left command.
- You will notice the Excel sheet will flip from the left to the right direction.
Finally, we can say that our process worked successfully, and we were able to flip the Excel sheet from left to right.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
Conclusion
That’s the end of this article. I hope that this article will be helpful for you and you will be able to flip the Excel sheet from left to right. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.
Related Articles
<< Go Back to Worksheets | Learn Excel
