column headings for multiple pages in Excel

I have created a report to list our daily purchase orders
received from vendors. This report has seven columns in
landscape mode. Some days I only have orders that fill
one page. However, some days there can be 2-3 pages
worth of orders. The first page has column headings.
How do I get these headings to print on all of the
subsequent pages?

"Claudia" wrote in message
...
I have created a report to list our daily purchase orders
received from vendors. This report has seven columns in
landscape mode. Some days I only have orders that fill
one page. However, some days there can be 2-3 pages
worth of orders. The first page has column headings.
How do I get these headings to print on all of the
subsequent pages?


File Page Setup Sheet tab, "Rows to repeat at top".

Go to FilePage Setup, and click on the tab that says
SHEET. In that view, click (Just one click) your cursor
in the blank (white) area to the right of "Rows to Repeat
at Top". Then move the cursor to the first (column
header) row of your worksheet and click anywhere in that
row. (YOu will see that the location has been printed in
the white box). Then click "OK", and your command will be
saved. This will enable column headers on all pages.

Hope this helps. Barbara

-----Original Message-----
I have created a report to list our daily purchase orders
received from vendors. This report has seven columns in
landscape mode. Some days I only have orders that fill
one page. However, some days there can be 2-3 pages
worth of orders. The first page has column headings.
How do I get these headings to print on all of the
subsequent pages?


.