Column headings in Excel showing up as numbers, not letters

[Dickster]

I think I accidentally hit a wrong key at the wrong time -
and all of a sudden, my column heading labels in Excel are
showing as numbers (i.e. 1,2,3, etc.) instead of letters
(i.e. A,B,C, etc.) - can anyone tell me how to recify
this.

 

[Bob Phillips]

Go to Tools>Options>General and uncheck the box marked R1C1 Reference
Style.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[SOS]

Click Tools/Options - General Tab and uncheck "R1C1 Reference Style
checkbox and there you go

Seamu

 

[Dickster]

OK - I tried that and this is what I got:
error msg: Name cannot resemble a reference
Old Name: e5
New Name: ______
I cannot find an "e5" anywhere in my spreadsheet

 

[Bob Phillips]

No you didn't, you did something else or it would have worked, but I have no
idea what.

Describe in detail what you did step by step.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Dickster

You have a range or cell named e5 referring to R5C5

When you try to change back from R1C1 notation you have e5 referring e5.

Insert>Name>Define. Either delete e5 or change to something else.

Gord Dibben Excel MVP

 

[Dickster]

Yup - did that - still no go - see previous reply

 

[Gord Dibben]

Dickster

Did you see my reply?

Gord Dibben Excel MVP

 

[Peter atherton]

-----Original Message-----
I think I accidentally hit a wrong key at the wrong time -

and all of a sudden, my column heading labels in Excel are
showing as numbers (i.e. 1,2,3, etc.) instead of letters
(i.e. A,B,C, etc.) - can anyone tell me how to recify
this.
.

Tools, Options, General and remove the checkmark against
R1C1 style.

Regards
Peter