close

How can one print the contents of the 1st column to each subsequent
pages?

If this require macros.... um, I don't know how to do that yet :-(

cheers

dayPage setup.....sheet.........column(s) to repeat at left

Greetings from New Zealand
Bill K
gt; wrote in message ups.com...
gt; How can one print the contents of the 1st column to each subsequent
gt; pages?
gt;
gt; If this require macros.... um, I don't know how to do that yet :-(
gt;
gt; cheers
gt;
gt; day
gt;

Printing the first column on each page does not require a macro. You
need to go to File, Page Setup, Sheet Tab and then under the quot;Columns
to repeat at leftquot; box simply choose which column you want to appear on
each page, in this case, column A:A.--
RJL0323
------------------------------------------------------------------------
RJL0323's Profile: www.excelforum.com/member.php...oamp;userid=19456
View this thread: www.excelforum.com/showthread...hreadid=513336and if you want to do the same thing for display you would select B1 to freeze
left column only or B2 to freeze left column and top row, and then use
Window, freeze panes.
Freeze Panes for view and Repeat row/col headings for printing
www.mvps.org/dmcritchie/excel/freeze.htm

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

    software

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