Column numbers/letters

A

Adam Turner

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

Paul

Adam Turner said:
Excel used to have lettered columns but this new version I'm using has
Click to expand...
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.
 
C

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
Click to expand...
using has numbered columns. Does anyone know how I can get my
lettered columns back?
 
P

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 **
Adam Turner said:
Excel used to have lettered columns but this new version I'm using has
Click to expand...
numbered columns. Does anyone know how I can get my lettered columns back?
 
Top