View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default change column header from numeric to alphac?

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.

Joe Haddad wrote:

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


--

Dave Peterson