How can I change column designation from number to letters?

G

Guest

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.
 
D

David M. Marcovitz

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column designation has started to appear as numbers 3
Change the column designation from a numeric to an alpha 2
How do columns headings change from letters to numbers? 5
Adding one to the number from the previous cell with text... 8
Change Excel column headers from numbers to letters 1
change column names to letters 1
Can I change the column heading from alphabetic to numeric? 2
How do I change column labels from numbers to letters? 2

Top