close

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?

toolsgt;optionsgt;generalgt;settingsgt;r1c1 uncheck

--
Don Guillett
SalesAid Software

quot;George Sladkyquot; lt;George gt; wrote in message
...
gt; On my version of Excel in Office 2000, the columns are headed in numeric
gt; values, as are the rows. This makes it confusing in entering formulas.
gt; Most
gt; versions of the spreadsheet have alpha column designations and numeric row
gt; designations. How can I change it to have columns headed by alpha
gt; charcters
gt; and rows by numeric designations?
Goto Toolsgt;Optionsgt;General and uncheck the R1C1 reference style checkbox.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()