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

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:

enter image description here


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


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