close

Is it possible to get the headings on the top of the first page to print on
the top of each page?


Go to Filegt;Page Setup, on the Sheet tab go to quot;Rows to Repeat at Topquot;
and select the desired rows.--
mphell0
------------------------------------------------------------------------
mphell0's Profile: www.excelforum.com/member.php...oamp;userid=30153
View this thread: www.excelforum.com/showthread...hreadid=503011Use the menu to Choose File-gt;Page Setup
Navigate to the Sheet tab and in the 2d box indicate the rows you want to
print at the top of each page

quot;J5quot; wrote:

gt; Is it possible to get the headings on the top of the first page to print on
gt; the top of each page?

Does anybody know whether it is possible to apply this to certain pages only.
For example, I have a fairly lengthy table which prints on several pages so I
want headings to appear on each page, I therefore do as has been pointed out
in this thread. But at the bottom of the table I have a number of notes which
run on to more than one page when printed, I therefore do not want the table
headings appearing on a printed page which only has notes on it.

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

    software

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