Excel is showing numbers as headers for both rows and columns??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rrgyoung - 10 Dec 2006 03:22 GMT

How do I change the column headers back to letters? Formulas will still work
if I use r1c1 format, but why did it change from letter headers on columns?

Reply to this Message

Dave Peterson - 10 Dec 2006 03:44 GMT

Tools|Options|General Tab
Uncheck the R1C1 reference style button.

Excel will pick this setting from the first workbook that it opens in that
session.

> How do I change the column headers back to letters? Formulas will still work
> if I use r1c1 format, but why did it change from letter headers on columns?

Signature

Dave Peterson

Reply to this Message

Les - 17 Dec 2006 01:18 GMT

Try this... Under Tools, open Options, then select the "General" tab. Under
Settings, see if R1C1 reference style is checked. If it is, clear it. That
should fix your problem.

Good luck!

> How do I change the column headers back to letters? Formulas will still work
> if I use r1c1 format, but why did it change from letter headers on columns?

Reply to this Message