ilc
Blogger
Share this content
0
2
1689

Excel relative cell name

Excel relative cell name

I have been sent a excel file where the column names are displayed as numbers as are the rows.  So the cell that would normally be B3 is displayed as R3C2, row3 column2.  I believe is called relative cell referencing.

How do I change this back to the norm?

Thanks in advance

Ian

Replies

Please login or register to join the discussion.

avatar
By MarkP
27th Oct 2010 15:09

Using Excel 2007...

Office Button, Excel Options, Formulas, "R1C1 reference style" - remove the tick

Thanks (0)
avatar
27th Oct 2010 15:40

Using Excel 2003...

...Is similar: 'Tools', 'Options', 'General' tab, untick 'R1C1 reference style'.

Cheers

Pat

Thanks (0)