Peter

My guess........

Hide the blocks of rows you don't want printed?


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 19:21:01 -0800, "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