worksheet has numbers where the letters are on top of the columns

Thread view:

Thread rating:

Linda - 25 Mar 2008 18:42 GMT

how do i get the letters back on top of the columns. some how they have
changed to numbers like on the rows.

thanks,

Signature

Linda

Gary''s Student - 25 Mar 2008 18:58 GMT

Tools > Options > General > clear the R1C1 checkbox

Signature

Gary''s Student - gsnu200775

> how do i get the letters back on top of the columns. some how they have
> changed to numbers like on the rows.
>
> thanks,

Tom Hutchins - 25 Mar 2008 19:01 GMT

In Excel 2003 & prior, select Tools >> Options. On the General tab, uncheck
'R1C1 reference style'. Click OK.

Hope this helps,

Hutch

> how do i get the letters back on top of the columns. some how they have
> changed to numbers like on the rows.
>
> thanks,

David Biddulph - 25 Mar 2008 19:13 GMT

Tools/ Options/ General:
Uncheck: R1C1 reference style
--
David Biddulph

> how do i get the letters back on top of the columns. some how they have
> changed to numbers like on the rows.
>
> thanks,