Excel Formulas are showing relative address, rather than absolute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Whoops!
Should be:
Tools:Options:General Tab:Settings, tick R1C1 Reference style

Ron@Buy said:
Tools:Options:View Tab:Window Options, tick Row & Column Headers

William Sporborg said:
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?
Click to expand...
Click to expand...
 
Thanks, Ron!

Ron@Buy said:
Whoops!
Should be:
Tools:Options:General Tab:Settings, tick R1C1 Reference style

Ron@Buy said:
Tools:Options:View Tab:Window Options, tick Row & Column Headers

William Sporborg said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top