How do you change Cell name reference from R[-2]C[-1] back to C2

R

rhind3833

How do you change this back to A1 B2 and so on. All cells are referenced by
row and colunm.

The cell name R[-2]C[-1] is what shows up when picking a cell that is 1
column left and 2 rows up.

I just want it back to C2
 
G

Gord Dibben

Tools>Options>General....uncheck R1C1 reference style.


Gord Dibben MS Excel MVP
 
R

rhind3833

Thanks

Gord Dibben said:
Tools>Options>General....uncheck R1C1 reference style.


Gord Dibben MS Excel MVP

How do you change this back to A1 B2 and so on. All cells are referenced by
row and colunm.

The cell name R[-2]C[-1] is what shows up when picking a cell that is 1
column left and 2 rows up.

I just want it back to C2
Click to expand...
Click to expand...
 
Top