Print several worksheets at once with fewer pages

S

Stephen POWELL

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
 
T

Trevor Shuttleworth

Stephen

assuming you had, say, 10 full rows on each sheet, you'd have a total of
1000 rows to print. If you *could* just print them one after the other at,
say, 60 rows per page, that would give you just under 17 pages. If you want
to allow a three row gap between blocks of data, you'd have just under 22
pages. If you could align some of the data side by side, you'd be down to
around 11 pages.

And, if your printer can print double sided then half it again.

So, a lot depends on how much data there is and how you want it presented.

Assuming you have that clear in your head, you could code a macro to page
through all the sheets and copy the *values* to a location on the "print
control" sheet.

Easy in theory

Regards

Trevor
 
J

Jay

I have about 100 worksheets, each has an identical structure.
The area on each worksheet to be printed is small. ...
Can I print all worksheets at once and use fewer than 50 double sided
pages?
Click to expand...

If you do this sort of thing a lot, "fineprint" might help:
http://www.fineprint.com/products/fineprint/index.html

Among its features is the ability to print four-up; that is, to print four
"pages" on one side of one sheet. Two-up and eight-up, too.

It isn't free, but it's worth the price if you use its features a lot.

(I'm not affiliated with fineprint except as a customer. It has been useful
to me.)
 
G

Gary Rowe

You could also try using the camera tool. The camera tool takes a picture of
the range of cells and you can place it on another sheet for printing along
with pictures of the other ranges so that you can get as many on a print area
as will fit. The picture of the range of cells has the range in the formula
bar and can be edited. The camera tool needs to be added by tools, customize
and drag the camera button to a toolbar.
Gary
 
S

Stephen POWELL

Thank you Jay. Your suggestion is something that I was not aware of. I will
look into this. Seems really interesting.
Stephen
 
S

Stephen POWELL

Gary:
Thank you for your suggestion. Given my limited skills with macros I am not
likely to make good use of your idea (given the repetitious nature of using
this feature on so many print areas), however, I can see how I could make use
of this in other instances.
Thanks again.
Stephen
 
Top