How to set the default page layout from RTL to LTR in Excel 2010?
up vote
13
down vote
favorite
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?
microsoft-excel microsoft-office right-to-left
edited Jan 14 '12 at 11:24
slhck
158k47436461
asked Jan 13 '12 at 19:06
yurib
5524918
add a comment |
up vote
13
down vote
favorite
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?
microsoft-excel microsoft-office right-to-left
edited Jan 14 '12 at 11:24
slhck
158k47436461
asked Jan 13 '12 at 19:06
yurib
5524918
add a comment |
up vote
13
down vote
favorite
up vote
13
down vote
favorite
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?
microsoft-excel microsoft-office right-to-left
edited Jan 14 '12 at 11:24
slhck
158k47436461
asked Jan 13 '12 at 19:06
yurib
5524918
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?
microsoft-excel microsoft-office right-to-left
microsoft-excel microsoft-office right-to-left
edited Jan 14 '12 at 11:24
slhck
158k47436461
asked Jan 13 '12 at 19:06
yurib
5524918
edited Jan 14 '12 at 11:24
slhck
158k47436461
asked Jan 13 '12 at 19:06
yurib
5524918
edited Jan 14 '12 at 11:24
slhck
158k47436461
edited Jan 14 '12 at 11:24
slhck
158k47436461
edited Jan 14 '12 at 11:24
slhck
158k47436461
158k47436461
asked Jan 13 '12 at 19:06
yurib
5524918
asked Jan 13 '12 at 19:06
yurib
5524918
asked Jan 13 '12 at 19:06
yurib
5524918
5524918
add a comment |
add a comment |
5 Answers
5
active
oldest
votes
up vote
14
down vote
accepted
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:
answered Jan 13 '12 at 19:35
bZezzz
67759
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
1
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
4
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
add a comment |
up vote
6
down vote
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
answered Jan 31 '13 at 10:14
hph
6111
add a comment |
up vote
5
down vote
This took me hours to figure out so I'll spare you the time:
Do this one time to change the default direction
Alt F11 to open the VBA editor
Ctrl g to open the Immediate window. In the Immediate window type
Application.DefaultSheetDirection = xlLTR
And press Enter
Alt q to close the VBA editor- Create a new workbook to test it
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
answered Oct 25 '12 at 17:14
Dan
5111
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find theSheet Right-to-Leftbutton, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g
– Serg
Jan 20 '13 at 18:05
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switchingxlLTRtoxlRTLworked
– Jonathan
Sep 27 '14 at 7:35
add a comment |
up vote
1
down vote
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)
answered Sep 27 '15 at 6:43
Zvi Storch
111
add a comment |
up vote
0
down vote
In Excel 2016:
File -> Options -> Advanced -> Display Area -> Default Directions
answered May 3 '17 at 8:11
Yakir Manor
1213
add a comment |
5 Answers
5
active
oldest
votes
5 Answers
5
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
14
down vote
accepted
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:
answered Jan 13 '12 at 19:35
bZezzz
67759
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
1
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
4
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
add a comment |
up vote
14
down vote
accepted
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:
answered Jan 13 '12 at 19:35
bZezzz
67759
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
1
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
4
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
add a comment |
up vote
14
down vote
accepted
up vote
14
down vote
accepted
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:
answered Jan 13 '12 at 19:35
bZezzz
67759
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:
answered Jan 13 '12 at 19:35
bZezzz
67759
edited Nov 26 at 20:23
answered Jan 13 '12 at 19:35
bZezzz
67759
answered Jan 13 '12 at 19:35
bZezzz
67759
answered Jan 13 '12 at 19:35
bZezzz
67759
67759
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
1
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
4
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
add a comment |
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
1
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
4
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
thebestdata.com/zoom.aspx?menutype=1&auto=2168
– bZezzz
Jan 13 '12 at 19:36
1
1
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
I took the liberty of quoting the most important parts and adding the screenshot from what you found. If the link ever goes down, that would be bad.. (see: Are answers that just contain links elsewhere really “good answers”?)
– slhck
Jan 14 '12 at 11:23
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
The first link is no longer available.
– Saar
Aug 21 '13 at 10:24
4
4
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
The screen shot shows how to change it one time, not how to make it permanent. The following answer is accurate (File->Options->Advanced->Display)
– Saar
Aug 21 '13 at 10:25
add a comment |
up vote
6
down vote
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
answered Jan 31 '13 at 10:14
hph
6111
add a comment |
up vote
6
down vote
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
answered Jan 31 '13 at 10:14
hph
6111
add a comment |
up vote
6
down vote
up vote
6
down vote
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
answered Jan 31 '13 at 10:14
hph
6111
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
answered Jan 31 '13 at 10:14
hph
6111
answered Jan 31 '13 at 10:14
hph
6111
answered Jan 31 '13 at 10:14
hph
6111
answered Jan 31 '13 at 10:14
hph
6111
6111
add a comment |
add a comment |
up vote
5
down vote
This took me hours to figure out so I'll spare you the time:
Do this one time to change the default direction
Alt F11 to open the VBA editor
Ctrl g to open the Immediate window. In the Immediate window type
Application.DefaultSheetDirection = xlLTR
And press Enter
Alt q to close the VBA editor- Create a new workbook to test it
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
answered Oct 25 '12 at 17:14
Dan
5111
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find theSheet Right-to-Leftbutton, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g
– Serg
Jan 20 '13 at 18:05
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switchingxlLTRtoxlRTLworked
– Jonathan
Sep 27 '14 at 7:35
add a comment |
up vote
5
down vote
This took me hours to figure out so I'll spare you the time:
Do this one time to change the default direction
Alt F11 to open the VBA editor
Ctrl g to open the Immediate window. In the Immediate window type
Application.DefaultSheetDirection = xlLTR
And press Enter
Alt q to close the VBA editor- Create a new workbook to test it
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
answered Oct 25 '12 at 17:14
Dan
5111
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find theSheet Right-to-Leftbutton, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g
– Serg
Jan 20 '13 at 18:05
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switchingxlLTRtoxlRTLworked
– Jonathan
Sep 27 '14 at 7:35
add a comment |
up vote
5
down vote
up vote
5
down vote
This took me hours to figure out so I'll spare you the time:
Do this one time to change the default direction
Alt F11 to open the VBA editor
Ctrl g to open the Immediate window. In the Immediate window type
Application.DefaultSheetDirection = xlLTR
And press Enter
Alt q to close the VBA editor- Create a new workbook to test it
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
answered Oct 25 '12 at 17:14
Dan
5111
This took me hours to figure out so I'll spare you the time:
Do this one time to change the default direction
Alt F11 to open the VBA editor
Ctrl g to open the Immediate window. In the Immediate window type
Application.DefaultSheetDirection = xlLTR
And press Enter
Alt q to close the VBA editor- Create a new workbook to test it
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
answered Oct 25 '12 at 17:14
Dan
5111
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
edited Oct 25 '12 at 17:50
Isaac Rabinovitch
2,5961728
2,5961728
answered Oct 25 '12 at 17:14
Dan
5111
answered Oct 25 '12 at 17:14
Dan
5111
answered Oct 25 '12 at 17:14
Dan
5111
5111
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find theSheet Right-to-Leftbutton, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g
– Serg
Jan 20 '13 at 18:05
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switchingxlLTRtoxlRTLworked
– Jonathan
Sep 27 '14 at 7:35
add a comment |
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find theSheet Right-to-Leftbutton, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g
– Serg
Jan 20 '13 at 18:05
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switchingxlLTRtoxlRTLworked
– Jonathan
Sep 27 '14 at 7:35
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find the
Sheet Right-to-Left button, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g– Serg
Jan 20 '13 at 18:05
Oh, thank you so much! I only wanted to view it left-to-right permanently. First, I spent half an hour to find the
Sheet Right-to-Left button, then another half an hour to make it default ... BTW, the VBA editor doesn't close with Alg-g– Serg
Jan 20 '13 at 18:05
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switching
xlLTR to xlRTL worked– Jonathan
Sep 27 '14 at 7:35
This worked for me on Office 2013. I specifically wanted the default to be RTL, so switching
xlLTR to xlRTL worked– Jonathan
Sep 27 '14 at 7:35
add a comment |
up vote
1
down vote
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)
answered Sep 27 '15 at 6:43
Zvi Storch
111
add a comment |
up vote
1
down vote
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)
answered Sep 27 '15 at 6:43
Zvi Storch
111
add a comment |
up vote
1
down vote
up vote
1
down vote
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)
answered Sep 27 '15 at 6:43
Zvi Storch
111
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)
answered Sep 27 '15 at 6:43
Zvi Storch
111
answered Sep 27 '15 at 6:43
Zvi Storch
111
answered Sep 27 '15 at 6:43
Zvi Storch
111
answered Sep 27 '15 at 6:43
Zvi Storch
111
111
add a comment |
add a comment |
up vote
0
down vote
In Excel 2016:
File -> Options -> Advanced -> Display Area -> Default Directions
answered May 3 '17 at 8:11
Yakir Manor
1213
add a comment |
up vote
0
down vote
In Excel 2016:
File -> Options -> Advanced -> Display Area -> Default Directions
answered May 3 '17 at 8:11
Yakir Manor
1213
add a comment |
up vote
0
down vote
up vote
0
down vote
In Excel 2016:
File -> Options -> Advanced -> Display Area -> Default Directions
answered May 3 '17 at 8:11
Yakir Manor
1213
In Excel 2016:
File -> Options -> Advanced -> Display Area -> Default Directions
answered May 3 '17 at 8:11
Yakir Manor
1213
answered May 3 '17 at 8:11
Yakir Manor
1213
answered May 3 '17 at 8:11
Yakir Manor
1213
answered May 3 '17 at 8:11
Yakir Manor
1213
1213
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f378111%2fhow-to-set-the-default-page-layout-from-rtl-to-ltr-in-excel-2010%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
