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

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

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

- - How do you change Cell name reference from R[-2]C[-1] back to C2 (https://www.excelbanter.com/excel-discussion-misc-queries/144932-how-do-you-change-cell-name-reference-r%5B-2%5Dc%5B-1%5D-back-c2.html)

rhind3833

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

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

Gord Dibben

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

ToolsOptionsGeneral....uncheck R1C1 reference style.

Gord Dibben MS Excel MVP

On Sat, 2 Jun 2007 08:37:00 -0700, rhind3833
wrote:

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

rhind3833

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

Thanks

"Gord Dibben" wrote:

ToolsOptionsGeneral....uncheck R1C1 reference style.

Gord Dibben MS Excel MVP

On Sat, 2 Jun 2007 08:37:00 -0700, rhind3833
wrote:

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

All times are GMT +1. The time now is 09:18 AM.