How to set the default page layout from RTL to LTR in Excel 2010?

Solution 1:

May look at this: UPDATED

In Excel 97-2003 there is always a option in Tools > Options on the International tab to change the default sheet direction. But in Excel 2007 there is only a option to change the default direction in Office Button > Excel Options ... Advanced if you have installed at least one RightToLeft language.
In Excel 2010 they add this option back in File > Options ... Advanced.

In Excel 2010:

Solution 2:

In Excel 2010: Please, follow this on the menu : File > Options ... Advanced , and scroll down your appearance scroll bar and find Display section then you can find Default direction on radio button then check it to what you want

Solution 3:

This took me hours to figure out so I'll spare you the time:

Do this one time to change the default direction

1. Alt F11 to open the VBA editor
2. Ctrl g to open the Immediate window. In the Immediate window type Application.DefaultSheetDirection = xlLTR And press Enter
3. Alt q to close the VBA editor
4. Create a new workbook to test it

Solution 4:

in office 2013, what you need to do is: go to: file>options>advanced>scroll down to "Display"> choose "left to right" or "right to left" (whatever you need)