how do you change excel columns from numerical to alpha
 

hi,

recently, and for no reason i know of, my excel worksheets now have numbers
along the top of the columns instead of the letters that used to be there.

frankly, i don't like it and preferred the alphabetical references
(especially for formula) but i can't figure out how to change it back.....any
ideas?

how do you change excel columns from numerical to alpha
 

Hi Ronnie,

Try:

Tools | Options | General | Uncheck the R1C1 reference style option


---
Regards,
Norman



"ronnie t blonde" <ronnie t wrote in
message ...
hi,

recently, and for no reason i know of, my excel worksheets now have
numbers
along the top of the columns instead of the letters that used to be there.

frankly, i don't like it and preferred the alphabetical references
(especially for formula) but i can't figure out how to change it
back.....any
ideas?

how do you change excel columns from numerical to alpha
 

fantastic!! it worked....you're a genius. thanks norman

"Norman Jones" wrote:

Hi Ronnie,

Try:

Tools | Options | General | Uncheck the R1C1 reference style option


---
Regards,
Norman



"ronnie t blonde" <ronnie t wrote in
message ...
hi,

recently, and for no reason i know of, my excel worksheets now have
numbers
along the top of the columns instead of the letters that used to be there.

frankly, i don't like it and preferred the alphabetical references
(especially for formula) but i can't figure out how to change it
back.....any
ideas?