Hi, Peter;
If your worksheet already has the data you want to print in the right
positions for your pre-printed forms,try something like this: copy the
contents of that sheet and Paste Special Formats into a new sheet. Then copy
and Paste Special Paste Link from only the cells you want to print into the
matching cells on your new sheet. Then use that one for printing.
Regards,
IanRoy.

"Peter" wrote:

Hello,
I have a single excel worksheet, and due to area's of the sheet I do not
want to have printed, (the data is to be printed onto pre printed forms),
have used the set print area option to exclude those area's.

The problem is now I have multiple pages inside a single worksheet. Each
page prints seperatly, so I end up with 5 pages with only a small amount of
the full worksheet on each.

Thanks in advance
Peter