header/footer margins on a second page??

[Ian Holm]

Hello,
I have a worksheet that is being printed out on an invoice sheet and it has
a header on the top of the paper.
My problem is that some invoices might have too many items on them and will
run on to the next page in the printer.
The next page has the same header on the sheet of paper so it prints at the
top of the paper and not in the right area.

Is thre any way to set margins or page layouts so that this doesn't happen?

(also i before print the spreadsheet will delete a few rows with data of a
certain criteria, so the rows will be moving)

would the answer be to use a footer that stays in one place?

thanks very much

Ian

 

[Rojee]

On the file menu select Page Setup
the select Sheet....Select for your Print Area
then select Rows to repeat at top