Columns numbered instead of alphabetical.

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have XL that opens with numbers across the columns that
should be alphabetical (ie A,B,C is now 1,2,3). I need
to get the column headers back to their alphabetical
form. The rows are still numeric so now A1 is 11 B1 is
12 etc. Never seen this before and have ran current
virus scans on pc.
Thanks.
CK
 
Hi
goto 'Tools - Options -View' and uncheck "R1C1 Reference Style"
 
Thank You...
-----Original Message-----
Hi
goto 'Tools - Options -View' and uncheck "R1C1 Reference Style"

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Thanks, but on my version (Excel 2002) it is under "tools"-
"Options"-General. You may have to look for it.
 
You must log in or register to reply here.

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

columns showing numbers instead of alphabets 1
format Column with horizontal alphabet label 3
Column headings to numbers and row headings to alphabets? 2
My Column display as "numbers" instead of "alphabets" 1
COLUMN HEADING CHANGED FROM ALPHABET TO NUMERIC 1
How can I vary the row number or column alphabet depending on my n 7
alphabetize entire rows by first word of first column 5
Column name instead of number 5

Back
Top