ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the worksheet or workbook direction (https://www.excelbanter.com/excel-discussion-misc-queries/188790-how-do-i-change-worksheet-workbook-direction.html)

Nate

How do I change the worksheet or workbook direction
 
I have an associate running Office 2007. The issue is that anytime they start
a new worksheet or workbook, the columns run Z-A instead of the standard A-Z.
I have tried everything that I can to correct it but with no luck. The
previous owner of the system was Arabic and had changed many settings to
reflect his language. I have reinstalled the Office software and I tried
everything I know. Now I need someone else's help as I am completely stumped!

Prashant Runwal[_2_]

How do I change the worksheet or workbook direction
 
Check your langaugae settings in excel through Excel options - Popular -
Language settings. Set primary editing language as the one you want. Close
excel and restart again. If this does not work then check regional and
language options in control panel of your operating system (May be you will
have to restart the machine and check again)

"Nate" wrote:

I have an associate running Office 2007. The issue is that anytime they start
a new worksheet or workbook, the columns run Z-A instead of the standard A-Z.
I have tried everything that I can to correct it but with no luck. The
previous owner of the system was Arabic and had changed many settings to
reflect his language. I have reinstalled the Office software and I tried
everything I know. Now I need someone else's help as I am completely stumped!


Nate

How do I change the worksheet or workbook direction
 
Thank you for your response. I have already tried these avenues to no
prevail. The regional and language setting are set to English and the Office
editing language is English with no others added. This is the reason I am so
confused. I changed all of that and it did change the Office language back to
English but did not change the worksheet direction.

"Prashant Runwal" wrote:

Check your langaugae settings in excel through Excel options - Popular -
Language settings. Set primary editing language as the one you want. Close
excel and restart again. If this does not work then check regional and
language options in control panel of your operating system (May be you will
have to restart the machine and check again)

"Nate" wrote:

I have an associate running Office 2007. The issue is that anytime they start
a new worksheet or workbook, the columns run Z-A instead of the standard A-Z.
I have tried everything that I can to correct it but with no luck. The
previous owner of the system was Arabic and had changed many settings to
reflect his language. I have reinstalled the Office software and I tried
everything I know. Now I need someone else's help as I am completely stumped!


Max

How do I change the worksheet or workbook direction
 
Recollect this posting by Roger Govier which might be of relevance:
http://tinyurl.com/4gaw9h

Quote:
" .. Press round Office ButtonExcel OptionCustomiseuse dropdown on Choose
Commands fromAll Commandsscroll down to Right to Left
DocumentHighlightAdd

This will place an icon on the QAT (Quick Access Toolbar) which, when
pressed will do what you require .."

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Prashant Runwal[_2_]

How do I change the worksheet or workbook direction
 
U r great max

"Max" wrote:

Recollect this posting by Roger Govier which might be of relevance:
http://tinyurl.com/4gaw9h

Quote:
" .. Press round Office ButtonExcel OptionCustomiseuse dropdown on Choose
Commands fromAll Commandsscroll down to Right to Left
DocumentHighlightAdd

This will place an icon on the QAT (Quick Access Toolbar) which, when
pressed will do what you require .."

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Nate

How do I change the worksheet or workbook direction
 
Max, Thank you very much. That, of course, corrected the issue. You are the
best.

"Max" wrote:

Recollect this posting by Roger Govier which might be of relevance:
http://tinyurl.com/4gaw9h

Quote:
" .. Press round Office ButtonExcel OptionCustomiseuse dropdown on Choose
Commands fromAll Commandsscroll down to Right to Left
DocumentHighlightAdd

This will place an icon on the QAT (Quick Access Toolbar) which, when
pressed will do what you require .."

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Max

How do I change the worksheet or workbook direction
 
Nate/Prashant,
Welcome, glad it helped. Full credits to Roger for his posting (I don't know
the steps in xl07). Do spare a moment to press the "Yes" button below, for
thread longevity.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nate" wrote:
Max, Thank you very much. That, of course, corrected the issue. You are the
best.




All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com