Why are my column headings numerical instead of alphabetical?

G

Guest

Microsoft Excel 2003
The column and row headings in my excel spreadsheet are both numerical. Cell
references are in the form of R1C1, R2C2 instead of the usual A1, B2, etc.
How do I change my column headings back to the alphabetical format?
 
R

Ron Rosenfeld

Microsoft Excel 2003
The column and row headings in my excel spreadsheet are both numerical. Cell
references are in the form of R1C1, R2C2 instead of the usual A1, B2, etc.
How do I change my column headings back to the alphabetical format?

Tools/Options/General/Settings and DEselect R1C1 Reference style


--ron
 

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

Top