Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column labels show as numbers and Row labels show as numbers
Help! I am using Excel 2003. Now my worksheets have reversed the column and
row labels. How do I change it back. I have exited Excel and when I open it again all the worksheets now show this way. I don't know what I did. -- Dianne Griffin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column labels show as numbers and Row labels show as numbers
Maybe...
Tools|Options|international tab|Uncheck the "View Current sheet right-to-left" Dianne Griffin wrote: Help! I am using Excel 2003. Now my worksheets have reversed the column and row labels. How do I change it back. I have exited Excel and when I open it again all the worksheets now show this way. I don't know what I did. -- Dianne Griffin -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column labels show as numbers and Row labels show as numbers
Sorry, I missed the subject.
Tools|Options|General tab|uncheck R1C1 reference style. This option is picked up from the first workbook you open in that session. So if someone is saving a workbook in R1C1 reference style, and you're unlucky enough to open that workbook first, you'll have to change it again. It could be a fight to the finish! Dianne Griffin wrote: Help! I am using Excel 2003. Now my worksheets have reversed the column and row labels. How do I change it back. I have exited Excel and when I open it again all the worksheets now show this way. I don't know what I did. -- Dianne Griffin -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column labels show as numbers and Row labels show as numbers
If you go to Tools-Options-General and under Settings, uncheck R1C1
reference style (style in which the columns are numbered) it should change the column headings back to letters. Good luck! "Dianne Griffin" wrote: Help! I am using Excel 2003. Now my worksheets have reversed the column and row labels. How do I change it back. I have exited Excel and when I open it again all the worksheets now show this way. I don't know what I did. -- Dianne Griffin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Column labels show as numbers | Excel Discussion (Misc queries) | |||
My Column 'Labels' (usually A-n....) now show numbers; why? | Setting up and Configuration of Excel | |||
How to show numbers on y-axis and percentages on data labels? | Charts and Charting in Excel | |||
How could my column labels become numbers instead of letters??? | Excel Discussion (Misc queries) | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) |