column headings problems
 

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?

column headings problems
 

ToolsOptionsGeneral tab
Uncheck: R1C1 reference style

Does that help?

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

XL2002, WinXP-Pro


"Wade" wrote:

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?

column headings problems
 

Wade

ToolsOptionsGeneral. Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP

On Wed, 25 Jan 2006 12:16:03 -0800, "Wade"
wrote:

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?

column headings problems
 

Thanks...that was very helpful

"Gord Dibben" wrote:

Wade

ToolsOptionsGeneral. Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP

On Wed, 25 Jan 2006 12:16:03 -0800, "Wade"
wrote:

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?

column headings problems
 

Thanks...that solved the problem

"Ron Coderre" wrote:

ToolsOptionsGeneral tab
Uncheck: R1C1 reference style

Does that help?

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

XL2002, WinXP-Pro


"Wade" wrote:

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?