number column header

  • Thread starter Thread starter tgmsr
  • Start date Start date
T

tgmsr

One day I launched my excel 2000 and was surprised to see
all column headers became numbers, 1, 2, 3, etc. instead
of normal alpha (A, B, C, etc)and they stay numeric even
opening previous excel files. Does anyone know how to put
headers back to alpha?
Thanks.
 
Tools, options, general, uncheck R1C1 reference style

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top