This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
If I print something in Excel for 25 copies and then open a new spreadsheet and only want to print one, why does it default back to 25 copies? This is costly because it does it all the time wasting paper! Why!?? How can I change that?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
I have worked for years as a computer administrator and have never had this happen before. This Excel program always prints the last number of copies I needed and if I don't specifically remember to make a point of putting a number in the print quantity box it defaults. Wastes paper!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 68%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Hi @Sandra Green,
I'm really understand your frustration and annoyance due to this situation since Excel is expected to always reset copy number to 1, not retaining the last copy count. I have also found a recent thread of a customer who also reports that the number of copies doesn't always default to 1 copy which can be caused by Printing Preferences settings or Printer driver's advanced properties options.
You can try the steps which I suggested in my initial response and also refer to the guide in this article to see if you are also in the same circumstances and try the provided workarounds to see whether it helps you situation either Why does the default number of copies to print keep changing? - Microsoft Q&A
Once again, I’m really sorry for the inconvenience this situation has caused you and I truly hope you will get this issue sorted out soon.
Should you have any further questions or need additional assistance, feel free to reach out. I'm happy to assist you further.
Thank you for your patience and understanding. Hope to hear from you soon.
Good day @Sandra Green,
Hope things are running smoothly on your end.
Following up on the support thread we've been working on. If you need assistance with anything else, kindly respond to this post, and I will be happy to help.
I want to make sure everything is working as expected and that your experience remains uninterrupted.
Thank you for your patience and understanding throughout the troubleshooting process.
I look forward to hearing from you soon.
Hi @Sandra Green,
Based on your sharing, it seems that Excel and/or your printer driver is remembering the last Printing setting and not reset automatically when you open a new workbook.
You can quickly and easily fix this issue by:
1/ Setting before printing
2/ Reset the printer default copies to 1
Hope my sharing may be helpful for your concern. If you have any questions or need any further clarification, please leave a comment here and I will be happy to continue to help you.
Thank you for your patience and understanding. I'm looking forward to your reply.
If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.