You would need a macro for that, here's one that you could adapt to fit

http://www.rondebruin.nl/print.htm#Breaks



--
Regards,

Peo Sjoblom



"GregB" wrote in message
...
Is there a function are macro to where i can make the each row on my sheet
print to an 8 by 11 page?

Any guidance or help is much appreciated.