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

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!

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

Hello Cotmc,

On the the menu go to ToolsOptionsGeneralSettings 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

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

Try this:

ToolsOptionsGeneral 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!

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

Yes! Thanks a million!

"Ron Coderre" wrote:

Try this:

ToolsOptionsGeneral 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!

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

Thanks!!

"Leith Ross" wrote:


Hello Cotmc,

On the the menu go to ToolsOptionsGeneralSettings 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