ExcelBanter - change view of cell references

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change view of cell references (https://www.excelbanter.com/excel-discussion-misc-queries/181265-change-view-cell-references.html)

Simon

change view of cell references

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

macropod

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.

All times are GMT +1. The time now is 03:27 AM.