Problem with Column header ID being 1 2 3 etc instead of A B C etc

M

MarcoKoenders

For some reason my column header Id show and has changed into numeric 1
instead of A, 2 instead of B, 3 instead of C.
When now selecting a cell like C5 the position is now R5C3.

What are the steps to recover this and get the normal column header A B C
back ?

Rgds
Marco
 
P

PCLIVE

Go to Tools | Options | General

Make sure "R1C1 reference style" is NOT checked.

Regards,
Paul
 
B

Bernard Liengme

In version before Excel 2007: Tools | Options ; open the General tab and
unselect the box "R1C1 reference style"

In Excel 2007: Office button; Excel Options; Formulas; Working with
Formulas; unselect the box "R1C1 reference style"

best wishes
 

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 coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Compare a column of substring with another column of strings and get count 2
Why is my header row numbers instead of letters? 2
Change column Name from 1 2 3 to A B C in excel 2007 1
excel-why do the columns A B C D etc and 1 2 3 4 etc print? 2
change column name from 1 2 3 to A B C in Excel 2007 2
Repeat value in column A by number in column B in column C 14
column & row names printed - a, b, c etc 1

Top