Excel Formulas are showing relative address, rather than absolute

  • Thread starter William Sporborg
  • Start date
W

William Sporborg

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?
 
R

Ron@Buy

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...
 
W

William Sporborg

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mixing absolute & relative reference 3
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2) 3
Formula for Cell address 3
Cell Address presents in Formula 1
Using icon sets with relative references 0
Change a cell reference from relative to absolute 2
Absolute value with a quick formula / shortcut? 3
How do I show web addresses in Excel, rather than their name 3

Top