Column numbers/letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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?
 
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?
 
Back
Top