Excel Formulas are showing relative address, rather than absol
Thanks, Ron!
"Ron@Buy" wrote:
Whoops!
Should be:
Tools:Options:General Tab:Settings, tick R1C1 Reference style
"Ron@Buy" wrote:
Tools:Options:View Tab:Window Options, tick Row & Column Headers
"William Sporborg" wrote:
The formula bar is showing relative addresses - eg =sum(R[-136]C;R etc,
rather than relative addresses, eg =sum(A1:B3). I must have inadvertenly
clicked a check box. How do I make it revert, please?
|