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