Excel shows column header's names as numbers(1,2,3) instead of chars (A,B,C,...)

D

David

Hi
I have a problem with Microsoft excel; as you can read on
the subject, when i open excel, it shows a data sheet like
this:

[] 1 2 3 4 5
1

2

3

4

(instead of the classic A B C D on the columns)
¿how can i change to chars? (well , the question should
be "how the f*** could i change it?", but i want to fix
it :) )

Thanks in advance

David
 
F

Frank Kabel

Hi
Go to Tools-Options-General and uncheck the box marked "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

Top