close

When I open a workbook, my column headers display as numbers rather than the
alpha characters. When I build formulas, the cell reference is for example
RC(-1). How can a restore the colums in my workbook to display as A, B, C...
and cells to show as A2, etc?

Hi
Toolsgt;Optionsgt;Generalgt;uncheck the R1C1 option.

--
Regards

Roger Govierquot;emitch511quot; gt; wrote in message
...
gt; When I open a workbook, my column headers display as numbers rather
gt; than the
gt; alpha characters. When I build formulas, the cell reference is for
gt; example
gt; RC(-1). How can a restore the colums in my workbook to display as A,
gt; B, C...
gt; and cells to show as A2, etc?

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

    software

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