how do i change column labels back to letters? currently columns.
 

when i opened excel this evening, i found that columns and rows are both
labeled with numbers. How do I relabel the columns alphabetically so that I
can use formulas? thanks

Click Tools Options General tab
Uncheck "R1C1 reference style" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"slthompson" wrote in message
...
when i opened excel this evening, i found that columns and rows are both
labeled with numbers. How do I relabel the columns alphabetically so that
I
can use formulas? thanks

thank you so much! I have a project that has to be finished, you know how
that is. With your help, I can now finish!

Lynn

"slthompson" wrote:

when i opened excel this evening, i found that columns and rows are both
labeled with numbers. How do I relabel the columns alphabetically so that I
can use formulas? thanks

Glad it helped, Lynn !
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"slthompson" wrote in message
...
thank you so much! I have a project that has to be finished, you know how
that is. With your help, I can now finish!

Lynn