My columns in excel are numbered rather than lettered-how to fix?
 

How do I fix this?

My columns in excel are numbered rather than lettered-how to fix?
 

hi
you didn't say what version xl you are using so....
2003 and earlier
on the menu bartoolsoptionsgeneral tabuncheck R1C1 reference
2007
Office buttonExcel optionsformulasuncheck R1C1 reference

regards
FSt1


"Ladybug" wrote:

How do I fix this?

My columns in excel are numbered rather than lettered-how to fix?
 

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

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Mon, 1 Mar 2010 12:53:01 -0800, Ladybug
wrote:

How do I fix this?