MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Columns have changed to numbers!

Posted by A.L. Staton on April 06, 2001 7:08 AM

Suddenly, for all worksbooks, the column headers have been replaced with numbers.
This is making a vertical lookup impossible.

Help me please.

Posted by Aladin Akyurek on April 06, 2001 7:12 AM

Change back the reference style via Tools|Options on the General tab by unchecking R1C1 reference style.

Posted by Ian on April 06, 2001 7:15 AM


Check under Tools-Options-General and deselect the R1C1 reference style.