How can I change column designation from number to letters?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Column headers numbers instead of letters 2
Columns are numbers instead of letters 4
column headings 1
Columns now numbers rather than letters how do i get letters back 2
Change Excel column headers from numbers to letters 1
How to change numbered columns to letters? 3
Column Heading Error 3

Back
Top