Printing multiple worksheets as a single printjob

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 ???
 
G

Guest

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 ???
 

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

printing multiple worksheets in a workbook 1
Printing multiple worksheets in a workbook 3
undesired "breaks" between worksheets 1
Printing Copies or multiple worksheets produces mult jobs 2
Printing single pages from multiple worksheets in a single print job 2
Printing Excel workbook 6
Not printing the entire workbook 2
Information from multiple worksheets to repeat on a single one 1

Top