I know how to select all sheets to print them all at once, but my
printer adds a cover sheet to each Excel Worksheet. I need to staple
all of the worksheets together as one document. Anyone know how?
In case you haven't found a useful approach yet, here’s one way --
admittedly not elegant.
Print the first sheet to the "Microsoft Office Document Image Writer."
This opens a "Microsoft Office Document Imaging" window for the sheet.
Do the same for several sheets, and there’ll be several windows: one per
sheet. You can use
Window > Arrange all
to see all the windows at once on the screen.
Next, combine the sheets into a single file. To do this, notice
that each of the "Imaging" windows has a left pane with thumbnails of the
page(s). Using right-click, "Copy" one or more thumbnails from the left
pane of one window and “Paste” it into the left pane of another.
Repeating this several times, the entire print job can be merged into a
single window.
Finally, print from that window.
If you do this sort of thing a lot, you might want to look into third-party
software like
http://fineprint.com/products/fineprint/index.html
It can (among many other features) combine several print jobs into one,
with fewer steps than using Image Writer.
