change column header from numeric to alphac?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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>.
 
Oh!
Thank you guys

Dave Peterson said:
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>.
Click to expand...
 
Joe Haddad said:
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
Click to expand...
 
Joe Haddad said:
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
Click to expand...

How do you do this in Excel 2007?
 
Button>Excel Options>Formulas>Working with formulas>R1C1 reference style.

Uncheck it.


Gord Dibben MS Excel MVP
 
Back
Top