column headings problems

G

Guest

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?
 
G

Guest

Tools>Options>General tab
Uncheck: R1C1 reference style

Does that help?

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

XL2002, WinXP-Pro
 
G

Gord Dibben

Wade

Tools>Options>General. Uncheck R1C1 reference style.


Gord Dibben MS Excel MVP
 
G

Guest

Thanks...that solved the problem

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

Does that help?

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

XL2002, WinXP-Pro
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Headings 3
How do I change column headings from A,B,C to actual words? 3
Headings of columns now have numbers, need to change them to lette 3
moving row data to a colunm in sorted order 9
HOW TO REVERSE THE ROW OR COLUMN HEADINGS 2
change Excel column headings from numbers to alpha characters 2
Column headings changed from alphabetical to numerical 2
I don't want row 1 as the column headings 1

Top