Excel 2002 - Column Labels are Numbers not Letters

P

Peter

On my Excel 2002 worksheets my column labels are numbers
just like the row labels. I expect to see letters. How
do I change this?
 
C

Chip Pearson

Peter,

Go to the Tools menu, choose Options, then the General tab. There, uncheck
the "R1C1 reference style" setting.
 

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

How to change column labels back to letters? 1
column labels 2
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
column headers 2
Column labels show as numbers and Row labels show as numbers 3
Column labels 4
EXCEL HEADINGS 2
Column Heading Error 3

Top