ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I change screen layout in Excel? (https://www.excelbanter.com/setting-up-configuration-excel/108243-how-do-i-change-screen-layout-excel.html)

D. Squires

How do I change screen layout in Excel?
 
I don't know how, but one of my students has changed a setting in Excel.
Column headings begin at the right side of the worksheet. Additionally, the
row headings are also shown on the right side of the worksheet. Everything
seems to be working in reverse within the worksheet. The toolbars and menu
bar are correctly shown on the screen. Can someone please help me with this?


Dave Peterson

How do I change screen layout in Excel?
 
Tools|Options|International tab|Right to left section.

And if/when you see 1 2 3 ... going across the top instead of A B C ..., you'll
find that under:
Tools|Options|General Tab|uncheck R1C1 reference style.



D. Squires wrote:

I don't know how, but one of my students has changed a setting in Excel.
Column headings begin at the right side of the worksheet. Additionally, the
row headings are also shown on the right side of the worksheet. Everything
seems to be working in reverse within the worksheet. The toolbars and menu
bar are correctly shown on the screen. Can someone please help me with this?


--

Dave Peterson

Dave Peterson

How do I change screen layout in Excel?
 
Ps. If this kid did this by accident, don't do this.

Bbut if he/she did it as a prank, you may want to look at John Walkenbach's
"menu Shenanigan's":

http://j-walk.com/ss/excel/files/general.htm



Dave Peterson wrote:

Tools|Options|International tab|Right to left section.

And if/when you see 1 2 3 ... going across the top instead of A B C ..., you'll
find that under:
Tools|Options|General Tab|uncheck R1C1 reference style.

D. Squires wrote:

I don't know how, but one of my students has changed a setting in Excel.
Column headings begin at the right side of the worksheet. Additionally, the
row headings are also shown on the right side of the worksheet. Everything
seems to be working in reverse within the worksheet. The toolbars and menu
bar are correctly shown on the screen. Can someone please help me with this?


--

Dave Peterson


--

Dave Peterson

D. Squires

How do I change screen layout in Excel?
 
Thank yolu for responding to my post. That solves my problem, and will
certainly keep the other students who share that computer from losing their
minds. Thank you again.

"Dave Peterson" wrote:

Tools|Options|International tab|Right to left section.

And if/when you see 1 2 3 ... going across the top instead of A B C ..., you'll
find that under:
Tools|Options|General Tab|uncheck R1C1 reference style.



D. Squires wrote:

I don't know how, but one of my students has changed a setting in Excel.
Column headings begin at the right side of the worksheet. Additionally, the
row headings are also shown on the right side of the worksheet. Everything
seems to be working in reverse within the worksheet. The toolbars and menu
bar are correctly shown on the screen. Can someone please help me with this?


--

Dave Peterson



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

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