Change the column designation from a numeric to an alpha

G

Guest

On my version of Excel in Office 2000, the columns are headed in numeric
values, as are the rows. This makes it confusing in entering formulas. Most
versions of the spreadsheet have alpha column designations and numeric row
designations. How can I change it to have columns headed by alpha charcters
and rows by numeric designations?
 
B

Bob Phillips

Goto Tools>Options>General and uncheck the R1C1 reference style checkbox.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

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

Column grid headings 2
how do I column heading to alpha from Numeric? 1
How do I change numeric column designations to alpha? 1
How can I change column headers from numeric to alpha? 2
Worksheet has numeric column headings. Change to alpha headings? 1
How do i change column header from R[1] C format to A1 format? 4
How can I change column designation from number to letters? 3
Converting RIC1 code to letter Column/Numeric Row 5

Top