Workbook is backwards! ~Help

[cujo1978]

I haven't changed any settings at all and all of my excel workbooks are reading right to left instead of left to right. How can I fix this? I have the 2013 version. I have gone into the advanced settings and it's set to read left to right but it's not. HELP!!

[TMS]

Press Alt-F11 to open the VBE
Press Ctrl-G to show the Immediate Window
Type: Application.DefaultSheetDirection = xlLTR 'or use xlRTL
and press Enter

Next time you create a new workbook, it should be back to normal.

Regards, TMS

[TMS]

And, for the current workbook: ActiveSheet.DisplayRightToLeft = Not ActiveSheet.DisplayRightToLeft


Regards, TMS

[cujo1978]

Bless you!!!! That worked perfectly!!!

[TMS]

You're welcome.




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.