C
Charlie
Cindy
To print the row 'A1' at the top of each sheet, go to page
setup, sheet tab. In the 'Print titles; section next to
the 'Rows to repeat at top' enter $1:$1. The Column
headings will appear on each page printed including the
last page. I do not know a way to eliminate printing on
the last page.
One possible method is to check the worksheet for
automatic page breaks and insert a new row under each
break and copy the header row into it. Easy to do on
small worksheet but not so great on large ones.
Let's hope one of the MVP reads this thread and comes up
with a better method.
Charlie O'Neill
choose which pages will have the repeating lines. In my
case, the lines are column headings, but I don't need the
column headings on the last page.
To print the row 'A1' at the top of each sheet, go to page
setup, sheet tab. In the 'Print titles; section next to
the 'Rows to repeat at top' enter $1:$1. The Column
headings will appear on each page printed including the
last page. I do not know a way to eliminate printing on
the last page.
One possible method is to check the worksheet for
automatic page breaks and insert a new row under each
break and copy the header row into it. Easy to do on
small worksheet but not so great on large ones.
Let's hope one of the MVP reads this thread and comes up
with a better method.
Charlie O'Neill
a worksheet except for the last page? In other words, to
choose which pages will have the repeating lines. In my
case, the lines are column headings, but I don't need the
column headings on the last page.