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?
Hi Ronnie,
Try:
Tools | Options | General | Uncheck the R1C1 reference style option---
Regards,
Norman
quot;ronnie t blondequot; lt;ronnie t gt; wrote in
message ...
gt; hi,
gt;
gt; recently, and for no reason i know of, my excel worksheets now have
gt; numbers
gt; along the top of the columns instead of the letters that used to be there.
gt;
gt; frankly, i don't like it and preferred the alphabetical references
gt; (especially for formula) but i can't figure out how to change it
gt; back.....any
gt; ideas?
gt;
gt;
fantastic!! it worked....you're a genius. thanks norman
quot;Norman Jonesquot; wrote:
gt; Hi Ronnie,
gt;
gt; Try:
gt;
gt; Tools | Options | General | Uncheck the R1C1 reference style option
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;
gt; quot;ronnie t blondequot; lt;ronnie t gt; wrote in
gt; message ...
gt; gt; hi,
gt; gt;
gt; gt; recently, and for no reason i know of, my excel worksheets now have
gt; gt; numbers
gt; gt; along the top of the columns instead of the letters that used to be there.
gt; gt;
gt; gt; frankly, i don't like it and preferred the alphabetical references
gt; gt; (especially for formula) but i can't figure out how to change it
gt; gt; back.....any
gt; gt; ideas?
gt; gt;
gt; gt;
gt;
gt;
gt;
- Jul 16 Mon 2007 20:38
how do you change excel columns from numerical to alpha
close
全站熱搜
留言列表
發表留言