Cant print multiple copies of a worksheet

J

Jeff

Having problems printing more than 1 copy of a worksheet, I go to file;print
then check "entire workbook" and change the # of copies to what I would like
(say 20)
it only prints 1. It does this on all my saved worksheets so I know there is
a major setting that got changed but I cant find which one.
 
B

Bob I

Some Printer drivers don't honor the request from excel, so you may have
to set the 20 in the printer properties setting rather than the Excel
Print dialog box.
 
G

Gord Dibben

What are you trying to print?

Subject line reads "multiple copies of a worksheet"

Then you state you selected "Entire Workbook"

You want 20 printed copies of one sheet or 20 copies of entire workbook?

20 copies of an entire workbook with multiple sheets could lead to mass
deforestation of the continent.

What is a "saved worksheet"?

You can only save workbooks, not worksheets.


Gord Dibben MS Excel MVP
 

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 copies 1
Print worksheet 2 on back of worksheet 1, etc.... 1
typing copies of worksheet together 1
Number of pages in worksheet doesn't match Print Preview pages 2
Print worksheets in external workbooks 2
Duplex Printing of Workbook with multiple worksheets 2
printing multiple copies of a worksheet 10
default number of copies 1

Top