View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David M. Marcovitz David M. Marcovitz is offline
external usenet poster
 
Posts: 11
Default How can I change column designation from number to letters?

Go to the Tools menu and choose Options. Go to the General tab and uncheck
the first item: R1C1 reference style.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

?B?SmFwYW5zcGVy?= wrote in
:

Both the columns and rows in my excel 2003 spreadsheets use number
designations. e.g. instead of cell A1 or 1A I get R1C1. How can I
switch to either lettered columns or lettered rows? The way its set
up now makes it very difficult for me to use relative and absolute
values in my equations.