ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Columns and Row headings switch to right side of screen (https://www.excelbanter.com/excel-worksheet-functions/128257-columns-row-headings-switch-right-side-screen.html)

Elbowes

Columns and Row headings switch to right side of screen
 

When inserting a new sheet into an existing workbook, the new sheet displays
the row numbers on the right side of the screen and the column headings read
from right to left. Everything is reversed. The original worksheet is
alright. What have I done wrong. Please help. Tks
Elbowes

Ron de Bruin

Columns and Row headings switch to right side of screen
 
Hi Elbowes

Look in your XLSTART folder
I think there is a workbook named Sheet.xlt
C:\Documents and Settings\<yourname\Application Data\Microsoft\Excel\XLSTART

Move it out of that folder

When you insert a sheet it use the settings from this sheet
ToolsOptions..International

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Elbowes" wrote in message ...

When inserting a new sheet into an existing workbook, the new sheet displays
the row numbers on the right side of the screen and the column headings read
from right to left. Everything is reversed. The original worksheet is
alright. What have I done wrong. Please help. Tks
Elbowes


Gord Dibben

Columns and Row headings switch to right side of screen
 
ToolsOptionsInternational

Your left to right and right to left settings can be changed here.


Gord Dibben MS Excel MVP

On Mon, 29 Jan 2007 13:36:01 -0800, Elbowes
wrote:


When inserting a new sheet into an existing workbook, the new sheet displays
the row numbers on the right side of the screen and the column headings read
from right to left. Everything is reversed. The original worksheet is
alright. What have I done wrong. Please help. Tks
Elbowes



Elbowes

Columns and Row headings switch to right side of screen
 

Tks loads for your speedy reply. Fixed problem in International settings
under Tools/options as suggested. Somehow it was set to read right to left.
Go figure. Tks Again
Elbowes


"Elbowes" wrote:


When inserting a new sheet into an existing workbook, the new sheet displays
the row numbers on the right side of the screen and the column headings read
from right to left. Everything is reversed. The original worksheet is
alright. What have I done wrong. Please help. Tks
Elbowes


David Biddulph

Columns and Row headings switch to right side of screen
 
Tools/ Options/ International/ Right-to-left
Choose appropriate options.
--
David Biddulph

"Elbowes" wrote in message
...

When inserting a new sheet into an existing workbook, the new sheet
displays
the row numbers on the right side of the screen and the column headings
read
from right to left. Everything is reversed. The original worksheet is
alright. What have I done wrong. Please help. Tks
Elbowes





All times are GMT +1. The time now is 09:49 PM.

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