18

Whenever I open an Excel spreadsheet, it is displayed in a right-to-left layout by default (i.e the right most column is A and I need to scroll to the left to reach further columns).

I can change the layout by going to the Page Layout menu and disabling the Sheet Right-to-Left button.

How can I do it permanently so all spreadsheets are opened in left-to-right mode by default?

slhck
  • 235,242
yurib
  • 1,242

5 Answers5

25

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

SLABB
  • 800
7

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

hph
  • 71
5

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
Isaac Rabinovitch
  • 2,864
Dan
  • 51
3

In Excel 2016:

File -> Options -> Advanced -> Display Area -> Default Directions enter image description here

Yakir Manor
  • 151
3

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)

Zvi Storch
  • 31