change column header from numeric to alphac?

[Guest]

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

 

[T. Valko]

Goto Tools>Options>General tab

Uncheck: R1C1 reference style

OK

Biff

 

[Dave Peterson]

Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks this setting up from the first workbook it opens in that session.
You'll want to remember this just in case you're unlucky <bg>.

 

[Guest]

Oh!
Thank you guys

Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks this setting up from the first workbook it opens in that session.
You'll want to remember this just in case you're unlucky <bg>.

 

[julia]

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

 

[julia]

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

How do you do this in Excel 2007?

 

[Gord Dibben]

Button>Excel Options>Formulas>Working with formulas>R1C1 reference style.

Uncheck it.


Gord Dibben MS Excel MVP