software

How do you get Excel 97 to print the header row at the top of each printed
page when the data is 300 or 400 rows long, for instance?

Jack

quot;Jackquot; gt; wrote in message
...
gt; How do you get Excel 97 to print the header row at the top of each printed
gt; page when the data is 300 or 400 rows long, for instance?
gt;
gt; Jack

1) Open a beer.

2) Click File, Page Setup, and then the Sheet tab.

3) Click in the quot;Rows to repeat at topquot; box to put the cursor there.

4) On the sheet itself, click in the cell which represents the left side of
the header row you want to print. Or, let's say your header is two rows
high. First, click in A1, hold the mouse button down, and drag down one cell
into A2. Now, two rows of header will print on each page.

5) The dialog box contains a Print Preview button so you can check the
results of the change you just made.
Doug,

I see quot;Rows to repeat at topquot; but it is grayed out and clicking in it
doesn't do anything Jackquot;Doug Kanterquot; gt; wrote in message
...

quot;Jackquot; gt; wrote in message
...
gt; How do you get Excel 97 to print the header row at the top of each printed
gt; page when the data is 300 or 400 rows long, for instance?
gt;
gt; Jack

1) Open a beer.

2) Click File, Page Setup, and then the Sheet tab.

3) Click in the quot;Rows to repeat at topquot; box to put the cursor there.

4) On the sheet itself, click in the cell which represents the left side of
the header row you want to print. Or, let's say your header is two rows
high. First, click in A1, hold the mouse button down, and drag down one cell
into A2. Now, two rows of header will print on each page.

5) The dialog box contains a Print Preview button so you can check the
results of the change you just made.

Jack

quot;Rows to repeat at topquot; will be be grayed out if you have accessed it through
Print Preview or if you have more than one worksheet selected.

Select one sheet and Filegt;Page Setupgt;Sheet.Gord Dibben MS Excel MVP

On Sat, 25 Feb 2006 18:35:07 -0500, quot;Jackquot; gt; wrote:

gt;Doug,
gt;
gt;I see quot;Rows to repeat at topquot; but it is grayed out and clicking in it
gt;doesn't do anything
gt;
gt;
gt;Jack
gt;
gt;
gt;quot;Doug Kanterquot; gt; wrote in message
...
gt;
gt;quot;Jackquot; gt; wrote in message
...
gt;gt; How do you get Excel 97 to print the header row at the top of each printed
gt;gt; page when the data is 300 or 400 rows long, for instance?
gt;gt;
gt;gt; Jack
gt;
gt;1) Open a beer.
gt;
gt;2) Click File, Page Setup, and then the Sheet tab.
gt;
gt;3) Click in the quot;Rows to repeat at topquot; box to put the cursor there.
gt;
gt;4) On the sheet itself, click in the cell which represents the left side of
gt;the header row you want to print. Or, let's say your header is two rows
gt;high. First, click in A1, hold the mouse button down, and drag down one cell
gt;into A2. Now, two rows of header will print on each page.
gt;
gt;5) The dialog box contains a Print Preview button so you can check the
gt;results of the change you just made.
gt;
gt;Gord --

That's it! Thanks!Jackquot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
Jack

quot;Rows to repeat at topquot; will be be grayed out if you have accessed it
through
Print Preview or if you have more than one worksheet selected.

Select one sheet and Filegt;Page Setupgt;Sheet.Gord Dibben MS Excel MVP

On Sat, 25 Feb 2006 18:35:07 -0500, quot;Jackquot; gt;
wrote:

gt;Doug,
gt;
gt;I see quot;Rows to repeat at topquot; but it is grayed out and clicking in it
gt;doesn't do anything
gt;
gt;
gt;Jack
gt;
gt;
gt;quot;Doug Kanterquot; gt; wrote in message
...
gt;
gt;quot;Jackquot; gt; wrote in message
...
gt;gt; How do you get Excel 97 to print the header row at the top of each
gt;gt; printed
gt;gt; page when the data is 300 or 400 rows long, for instance?
gt;gt;
gt;gt; Jack
gt;
gt;1) Open a beer.
gt;
gt;2) Click File, Page Setup, and then the Sheet tab.
gt;
gt;3) Click in the quot;Rows to repeat at topquot; box to put the cursor there.
gt;
gt;4) On the sheet itself, click in the cell which represents the left side of
gt;the header row you want to print. Or, let's say your header is two rows
gt;high. First, click in A1, hold the mouse button down, and drag down one
gt;cell
gt;into A2. Now, two rows of header will print on each page.
gt;
gt;5) The dialog box contains a Print Preview button so you can check the
gt;results of the change you just made.
gt;
gt;