Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Column Headers have numbersPosted by Mike on October 23, 2001 3:14 PM
My column headers have changed from letters to numbers. It's happening in anumber of sheets I open.
Any ideas how to change it back?
Re: Column Headers have numbersPosted by Jonathan on October 23, 2001 3:22 PM
Tools/Options/General/ uncheck R1C1 reference style.
Re: Column Headers have numbersPosted by Aladin Akyurek on October 23, 2001 3:24 PM
Activate Tools|Options, deactivate R1C1 reference style on the General tab (on the Mac, activate Edit|preferences).
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.