my column headers has changed to numeric from alphabetcal order

G

Guest

I have come across strange problem ..my column names has chnaged to numeric
from alphabet and now none of my formulaes work as all the cell names show
up as R1C1 , R1C2 and so on...

Anyone knows what have i messed up ???
 
N

Norman Jones

Hi Annie,

Try:

Tools | Options | General Tab | Uncheck R1C1 reference style.
 

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

Restoring columns 2
Can I change the column heading from alphabetic to numeric? 2
Excel 2007 Numerical Column Headers 4
Rename columns header from Alphabet to Numeric 1
Why are my column headings numerical instead of alphabetical? 1
How do change excel columns from alphabetic to numeric 1
how can I sort a column numerically with both words and numbers i. 2
How change worksheet axis to alpha numerical not both numer 1

Top