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

HELP!!!
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

R1C1?

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