why have column letters changed to numbers in excel

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
 
D

David Biddulph

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"
 

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
Row headings have changed from letters to numbers. How do I undo? 2
Changing grey column headings from numbers back to capital letters 2
why have my column headings changed to numbers 1
Column Heading Error 3
Column chngd fm letters to numbers. What that & how do I go back? 1
column display, letters or numbers 1
Column Headings 2

Top