Excel Formulas are showing relative address, rather than absolute
 

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?

Excel Formulas are showing relative address, rather than absolute
 

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?

Excel Formulas are showing relative address, rather than absol
 

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?

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?