number column header

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.
 
P

Paul B

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 **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding matrix headers 1
Column Headings 3
Excel XP. column headings are numeric I want alpha 1
How do I change my column designator from Numeric to Alpha? 1
How do I change my column headers? 1
Column and Row header 3
Question about hacking web-mail (hotmail) accounts 7
Sorting Alphanumeric data 6

Top