Printing multiple worksheets as a single printjob

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When printing multiple worksheets I have not been able to do it in a single print job. In this particular situation, it breaks it down in 3 printjobs, and that gets in the way, because I am printing to a PDF generator, and I would like to see 1 file as the outcome of the task.

Any ideas ???
 
Andre
You can select multiple worksheets by selecting the first sheet and holding the shift key and selecting the last sheet. If you need non-contiguous sheets then hold the control key and select the sheets you need

However, if you have a header or footer with page numbers in it this will mess up the numbering. If each sheet consists of 1 page , instead of getting page 1 of 1 three times, you will get 1 of 3, 2 of 3 and 3 of 3

Good Luck
Mark Graesse
(e-mail address removed)

----- Andre wrote: ----

When printing multiple worksheets I have not been able to do it in a single print job. In this particular situation, it breaks it down in 3 printjobs, and that gets in the way, because I am printing to a PDF generator, and I would like to see 1 file as the outcome of the task

Any ideas ???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - cannot print several sheets in color 5
Excel VBA - Problem with Closing Print Preview 0
Printing single pages from multiple worksheets in a single print job 2
excel 2003 - printing multiple worsheet splits 1 printjob in 2 4
Printing multiple worksheets in a workbook 3
Print preview/page set-up is printing 100's of blank pages 2
printing multiple worksheets in a workbook 1
Can you print separate worksheet on a single page? 3

Back
Top