Worksheet Column Labels ... Alphabet or Numeric ?

M

monir

Hello;

When I open myBook.xls, the worksheet column labels are displayed, for a
mysterious reason, as 1, 2, 3, ..., etc.
Now, while myBook.xls is open, when I open any other w/b or even a new w/b,
its column labels are displayed also as 1, 2, 3, ...

Close everything. Now open a w/b that, for whatever reason, displays its
column labels as A, B, C, ..., and re-open myBook.xls. The latter now
displays the column labels as A, B, C, ...

1. Could you please advise on why this is happening ??
2. Are the w/s column labels (alphabet, numeric, Greek symbols, etc.) an
aplication option or a w/b setting ??
3. Where is this option selected, if any ??

Thank you kindly.
 
M

Michael

Hi Monir. After you open a file, all subsequent files that you open will
have the same characteristics. Go to the Tools menu, Options and select the
General tab. When the Column labels are numeric the R1C1 reference style box
is checked. Uncheck it. HTH
 

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