Change the column designation from a numeric to an alpha

[George Sladky]

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?

[Don Guillett]

tools>options>general>settings>r1c1 uncheck

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"George Sladky" <George Sladky@discussions.microsoft.com> wrote in message
news:7E24DBA2-CE2F-43F1-9698-1E772DE9D0D5@microsoft.com...
> 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?

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"George Sladky" <George Sladky@discussions.microsoft.com> wrote in message
news:7E24DBA2-CE2F-43F1-9698-1E772DE9D0D5@microsoft.com...
> 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?