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

G

Guest

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
 
G

Guest

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...
 

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

reference format and column name 1
change change cell reference to Absolute reference 5
Formula Question 2
mr t.valko ..help 8
Cell References Format 2
Blank Cell Reference, without if statement 4
why does formula not work until I clear referenced cell ?? 3
How do I find data excluded from a list in excel? 2

Top