How do I Change column labels to ABC from 123 ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel normally has colomn labels (i.e. A, B, C, . . .) , but I see colmn
labels that are the same as the row labels (i.e. 1,2,3, . . .). How can I
change it back to ABC?

NOTE:
I want to write a formula (i.e. 2C=1A+1B).
Exsiting: is something strange (i.e. =RC[-4]+RC[-3]) that I don't understand.
 
tools>options>general>r1c1

--
Don Guillett
SalesAid Software
(e-mail address removed)
Jeff said:
Excel normally has colomn labels (i.e. A, B, C, . . .) , but I see colmn
labels that are the same as the row labels (i.e. 1,2,3, . . .). How can I
change it back to ABC?

NOTE:
I want to write a formula (i.e. 2C=1A+1B).
Exsiting: is something strange (i.e. =RC[-4]+RC[-3]) that I don't
Click to expand...
understand.
 
You must log in or register to reply here.

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

Pivot table - display all labels (i.e: do not summarise) how to? 1
how can i change the row from 123 to ABC 1
How to change the column headers from ABC to 123 2
column heading label 1
Changing column heads from ABC to 123 2
How do I change the column ID in Excel from number to text? 5
formula bar displays "=RC[-12]+RC[-11]". how to get normal view? 3
Combine information from two pages, two changing locations. 6

Back
Top