MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column Headers have numbers

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

Posted by Jonathan on October 23, 2001 3:22 PM

Tools/Options/General/ uncheck R1C1 reference style.

Posted 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).