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?
slhck3- Preferably better to have the flexibility and possibility to change this from the site identity itself for example; – IF RTL logo in the left ( site title – site tagline ) in the right – IF RTL logo in the right ( site title – site tagline ) in the left. – Main menu bar for RTL language home button ALWAYS start from right.
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:
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
Application.DefaultSheetDirection = xlLTR
And press Enterin 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)
In Excel 2016:
File -> Options -> Advanced -> Display Area -> Default Directions