Thread: How do you change Cell name reference from R[-2]C[-1] back to C2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote