View Single Post
  #1   Report Post  
Stephen POWELL
 
Posts: n/a
Default Print several worksheets at once with fewer pages

I have about 100 worksheets, each has an identical structure.
The area on each worksheet to be printed is small.
If these areas were moved to co-exist on the same worksheet then the number
of pages required to print everything would be a fraction of 100. (Moving
these areas onto one worksheet is not an option given other reasons for
structuring the workbook the way it is.)
Can I print all worksheets at once and use fewer than 50 double sided pages?
Many thanks,
Stephen Powell