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.

Click Tools, Options, General, R1C1

Japansper wrote:

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.

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.

Try

Tools|Options|general and un-check R1C1

Mike

"Japansper" wrote:

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.