ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I Change column labels to ABC from 123 ? (https://www.excelbanter.com/excel-worksheet-functions/26170-how-do-i-change-column-labels-abc-123-a.html)

Jeff

How do I Change column labels to ABC from 123 ?
 
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.

Don Guillett

toolsoptionsgeneralr1c1

--
Don Guillett
SalesAid Software

"Jeff" wrote in message
...
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.




All times are GMT +1. The time now is 06:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com