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

[barnes76]

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.

[Bob Phillips]

Go to Tools>Options and on the General tab, uncheck the R1C1 Reference Style
checkbox.

--

HTH

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


"barnes76" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Max]

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

"barnes76" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"barnes76" <[email protected]> wrote in message
news:[email protected]...
> 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]

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 <at>yahoo<dot>com
> ----
>
> "barnes76" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

[Max]

"barnes76" wrote:
> Thank you very much!

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----