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?
- Jun 22 Fri 2007 20:37
How do I restore column amp; row cell references
close
全站熱搜
留言列表
發表留言