Reversing headers from right to left, and switch place of scroll bar and rows

[bearcub]

This is very stang. Most of my file is set up with the column headers going from left to right (A, B, C, D, etc). On one sheet, though, I have the column headers starting from the right so it is starting with column A is in the top right corner not the left hand corner of my screen.

The Scroll bar is on the left side and the row numbers are on the right side. The horizontal scroll bar is now on the left side of my screen instead of on the right side. In other words, the sheet has been reversed (flip flopped).

The other sheets in my file are normal - A1 starts in the top left corner of my screen and the scroll bar is located on the the right had side. Why is this one sheet different than all the other sheets (I must have about 20 sheets in the file).

Do you know how I can fix this?

Thank you in advance,

Michael

 

[tonyyy]

Michael,

Sounds like the "Show sheet right-to-left" option has been turned on. To turn it off, uncheck the option...

File / Options / Advanced / Display options for this worksheet / Show sheet right-to-left

Cheers,

tonyyy

 

[bearcub]

That was it, thank you. I originally looked in the advance options but missed that section.

 

[tonyyy]

You're very welcome...