Thread: How do I change sheet notation from R1C1 style to A1 style in XL 2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default How do I change sheet notation from R1C1 style to A1 style in XL 2
Office ButtonExcel optionsformulasunder 'working with formulas' section,
un-check R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Sherlock1506" wrote in message
...
Since the configuration system is different in Excel 2007 from previous
versions, I am unable to determine how to change the sheet notation from
the
R1C1 style (default) to the A1 style (preferred). Thanks in advance.

Reply With QuoteReply With Quote