close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()