close

i want row and column titles to automatically fill into place in a working
spreadsheet, but i do not know how.

can someone tell me how to do this?

I'm not sure whether you want col/row titles to be on every page when
printing or to always be visible when viewing the worksheet.

For printing:
lt;filegt;lt;page setupgt;lt;sheet tabgt;
Set: rows and columns to repeat

For viewing:
Select the 1st cell below the col titles and to the right of the row titles
lt;windowgt;lt;freeze panesgt;

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;antoniokcquot; wrote:

gt; i want row and column titles to automatically fill into place in a working
gt; spreadsheet, but i do not know how.
gt;
gt; can someone tell me how to do this?

thank, ron, for helping me out with this. i managed to print out my document
exactly as i wanted it!

best,
antonio

quot;Ron Coderrequot; wrote:

gt; I'm not sure whether you want col/row titles to be on every page when
gt; printing or to always be visible when viewing the worksheet.
gt;
gt; For printing:
gt; lt;filegt;lt;page setupgt;lt;sheet tabgt;
gt; Set: rows and columns to repeat
gt;
gt; For viewing:
gt; Select the 1st cell below the col titles and to the right of the row titles
gt; lt;windowgt;lt;freeze panesgt;
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;antoniokcquot; wrote:
gt;
gt; gt; i want row and column titles to automatically fill into place in a working
gt; gt; spreadsheet, but i do not know how.
gt; gt;
gt; gt; can someone tell me how to do this?

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

    software

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