Column numbers/letters

[Guest]

Excel used to have lettered columns but this new version I'm using has numbered columns. Does anyone know how I can get my lettered columns back?

 

[Paul]

Excel used to have lettered columns but this new version I'm using has

numbered columns. Does anyone know how I can get my lettered columns back?

Tools > Options > General tab
Uncheck R1C1 reference style.

This is not a change between versions but a setting that has always been
there. In your Excel for some reason it is now set differently.

 

[Chip Pearson]

Adam,

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message

Excel used to have lettered columns but this new version I'm

using has numbered columns. Does anyone know how I can get my
lettered columns back?

 

[Paul B]

Adam, tols, options, general, and uncheck R1C1 reference style

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Excel used to have lettered columns but this new version I'm using has

numbered columns. Does anyone know how I can get my lettered columns back?