J
Jack
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
page when the data is 300 or 400 rows long, for instance?
Jack
D
Doug Kanter
Jack said:
1) Open a beer.
2) Click File, Page Setup, and then the Sheet tab.
3) Click in the "Rows to repeat at top" 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.
J
Jack
Doug,
I see "Rows to repeat at top" but it is grayed out and clicking in it
doesn't do anything
Jack
1) Open a beer.
2) Click File, Page Setup, and then the Sheet tab.
3) Click in the "Rows to repeat at top" 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.
I see "Rows to repeat at top" but it is grayed out and clicking in it
doesn't do anything
Jack
Jack said:
1) Open a beer.
2) Click File, Page Setup, and then the Sheet tab.
3) Click in the "Rows to repeat at top" 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.
G
Gord Dibben
Jack
"Rows to repeat at top" 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 File>Page Setup>Sheet.
Gord Dibben MS Excel MVP
"Rows to repeat at top" 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 File>Page Setup>Sheet.
Gord Dibben MS Excel MVP
J
Jack
Gord --
That's it! Thanks!
Jack
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Jack
"Rows to repeat at top" 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 File>Page Setup>Sheet.
Gord Dibben MS Excel MVP
That's it! Thanks!
Jack
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Jack
"Rows to repeat at top" 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 File>Page Setup>Sheet.
Gord Dibben MS Excel MVP