View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How can I change column designation from number to letters?

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.