column headings problems

Wade · Jan 25, 2006

My view of the column headings has changed from A,BC's to numbers. Now the
rows and columns have numbers. Therefore my formulas no longer have alphabet
vaulues in them. How do I change them back?

Ron Coderre · Jan 25, 2006

Tools>Options>General tab
Uncheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

Gord Dibben · Jan 25, 2006

Wade

Tools>Options>General. Uncheck R1C1 reference style.

Gord Dibben MS Excel MVP

Wade · Jan 25, 2006

Thanks...that was very helpful

Gord Dibben said:
Wade

Tools>Options>General. Uncheck R1C1 reference style.

Gord Dibben MS Excel MVP

Wade · Jan 25, 2006

Thanks...that solved the problem

Ron Coderre said:
Tools>Options>General tab
Uncheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro