View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod macropod is offline
external usenet poster
 
Posts: 329
Default change view of cell references

Hi Simon,

Access the Excel Options (eg Alt-T, O), choose 'Formulas' and uncheck 'R1C1 reference style'.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Simon" wrote in message ...
My cell references in excel are displayed as RC[-2]. How do I change to more
convential R3C2. I am using Office 2007.