Column heading changed from letters to numbers

  • Thread starter Thread starter joe busch
  • Start date Start date
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
 
Joe,

Go to the Tools menu, choose Options, then the General tab. There, uncheck
the "R1C1 reference style" setting.
 
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...
 
Thanks to you too Chip.
JB
Chip Pearson said:
Joe,

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)
Click to expand...
 
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
 
Back
Top