Thread: Excel Formulas are showing relative address, rather than absolute
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
  
Posts: 345
Default 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?
Reply With QuoteReply With Quote