How do I change Excel column cell identifiers back to letters?

[cotmc]

While merging data from different worksheets and formatting cells, I suddenly
noticed the column identifiers at the top of my worksheet changed to numbers
instead of letters. Any good ideas on how I should change them back to
letters? I searched Help Online and came up empty thus far. Thanks!

[Leith Ross]

Hello Cotmc,

On the the menu go to Tools>Options>General>Settings and click the box marked R1C1 style to clear it.

Sincerely,
Leith Ross

[Ron Coderre]

Try this:

Tools>Options>General tab
UNcheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"cotmc" wrote:

> While merging data from different worksheets and formatting cells, I suddenly
> noticed the column identifiers at the top of my worksheet changed to numbers
> instead of letters. Any good ideas on how I should change them back to
> letters? I searched Help Online and came up empty thus far. Thanks!

[cotmc]

Yes! Thanks a million!

"Ron Coderre" wrote:

> Try this:
>
> Tools>Options>General tab
> UNcheck: R1C1 reference style
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "cotmc" wrote:
>
> > While merging data from different worksheets and formatting cells, I suddenly
> > noticed the column identifiers at the top of my worksheet changed to numbers
> > instead of letters. Any good ideas on how I should change them back to
> > letters? I searched Help Online and came up empty thus far. Thanks!

[cotmc]

Thanks!!

"Leith Ross" wrote:

>
> Hello Cotmc,
>
> On the the menu go to Tools>Options>General>Settings and click the box
> marked R1C1 style to clear it.
>
> Sincerely,
> Leith Ross
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=503418
>
>