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

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

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

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