Columns in Excel are numbers instead of letters, how do I change .
 

Recently when I open Excel, both the rows and columns are numbers. They are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine. The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.

Click Tools Options General tab
Uncheck "R1C1 reference style" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"barnes76" wrote in message
...
Recently when I open Excel, both the rows and columns are numbers. They
are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine.
The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.

Go to ToolsOptions and on the General tab, uncheck the R1C1 Reference Style
checkbox.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"barnes76" wrote in message
...
Recently when I open Excel, both the rows and columns are numbers. They
are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine.
The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.

Tools=Options=general tab, unclick R1C1 Reference Style.

--
Regards,
Tom Ogilvy


"barnes76" wrote in message
...
Recently when I open Excel, both the rows and columns are numbers. They
are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine.
The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.

Thank you very much!

"Max" wrote:

Click Tools Options General tab
Uncheck "R1C1 reference style" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"barnes76" wrote in message
...
Recently when I open Excel, both the rows and columns are numbers. They
are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine.
The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.

"barnes76" wrote:
Thank you very much!

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----