columns

J

Jon

How come when I sometimes open Excel.. the columns are
headed with numbers and not letters? How do I stop this
from happening?

Thanks
 
A

Anon

Jon said:
How come when I sometimes open Excel.. the columns are
headed with numbers and not letters? How do I stop this
from happening?

Thanks

Tools > Options > General tab, uncheck R1C1 reference style.
 
S

Stephen Dunn

IIRC this is a setting that is taken from the first file opened. So,
anytime this happens, change the setting given by Anon, then save the file.
 

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