why have column letters changed to numbers in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason the column headings have changed from letters to numbers.
Row headings still appear with numbers. This is happening in all my excel
workbooks so it must be some sort of global change that I have inadvertantly
made. Does anyone know why and what I need to do to change it back. (Excel
in Office 2000.)

Many thanks
 
JCereda said:
For some reason the column headings have changed from letters to numbers.
Row headings still appear with numbers. This is happening in all my excel
workbooks so it must be some sort of global change that I have inadvertantly
made. Does anyone know why and what I need to do to change it back. (Excel
in Office 2000.)
Click to expand...

Tools/ Options/ General:
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Why are column headings numbers instead of letters? 1
why have my column headings changed to numbers 1
Columns change from letters to numbers 2
In Excel why have column headings gone from Letters to Numbers 3
Excel 2007... fix column headings from numbers back to letters 4
Changing grey column headings from numbers back to capital letters 2
Columns are numbers instead of letters 4

Back
Top