Column Headings from Numbers back to Letters

  • Thread starter Thread starter Martha W. Stone
  • Start date Start date
M

Martha W. Stone

Why do my excel randomly open a document with numbers for the column
headings instead of the usual letters?

How can I fix it and change it back?
 
Hi

This option is determined by the first book that is opened. One (or more) of
your books must have this setting - hence your problem.
You need to find this book, change the option, and save.
 
Hi
goto 'Tools - Options -View' and uncheck "R1C1 Reference Style"
 
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

Excel 2007... fix column headings from numbers back to letters 4
Column Heading 1
Why are column headings numbers instead of letters? 1
Changing grey column headings from numbers back to capital letters 2
column headings 3
Excel - Column headings 1
Column Heading Error 3
why have my column headings changed to numbers 1

Back
Top