"GS" wrote:

Remove the pagebreaks AND set 1 pages wide by 3 pages tall! Adjust page
margins to render maximum scale. Note that any pagebreaks you set should
be ignore when using the pages wide x pages tall option anyway, but if
your predesigned template must print 3 pages max then 1 x 3 will do that
consistently!

I will give this a try today. But....

If I set it to 3 pages tall, how will Excel know the begining and end of
each of my pages? Our first two pages have 50 rows of data, while
the last page has 30 rows of data.

I probably need to re-design each sheet, right?


(Not sure why this wasn't built into the sheet at design time??)


The sheet was designed by someone else who only had a basic understanding
of Excel. They wanted to get rid of paper forms and go digital. I don't
think they considered that sometimes we do need to print out a paper
inventory form.