change row labels; r1c1 to a1

bob hawkins · Dec 14, 2003

somehow i've changed my lables--row, column--from a12, b10, etc--to r1c5,
r2c7, etc

how do i change back?

thanks,

bob
dallas

Gord Dibben · Dec 14, 2003

Bob

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

Gord Dibben Excel MVP