Column heading changed from letters to numbers

J

joe busch

Using Excel 2000, all my spreadsheets have changed from having letters at
the top of the columns to numbers. How do I change back?

Joe Busch
 
C

Chip Pearson

Joe,

Go to the Tools menu, choose Options, then the General tab. There, uncheck
the "R1C1 reference style" setting.
 
J

joe busch

Thanks Ken!

Ken Wright said:
Tools / Options / General / Uncheck 'R1C1 reference Style'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

-------------------------------------------------------------------------- --
Attitude - A little thing that makes a BIG difference
-------------------------------------------------------------------------- --
Click to expand...
 
L

luis

I had the same problem using Excel 2002. The solution was:
1. Go to Tools --> Options
2. Go to the General tab.
3. Under Setting, uncheck the option R1C1 reference style.
4. Click in OK
That's all
 
Top