change view of cell references

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

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

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

Cheers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change formula RC to Cell reference value Excel 2007 2
Naming a cell from VB 3
Help with macro 3
Named range with multiple groups of cells 4
coloring cells that contain formula 5
Compatibility Question 3
Excel How to code in excel vba 2007 using absolute refernce for cells 1
macro to copy following cells in the same column 4

Back
Top