'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for Mac Printing Only One Copy
Question details
Users are unable to change the number of copies when printing a workbook in Excel for Mac, as the application retains the number of copies selected during the initial print job.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Printing multiple copies of an Excel workbook on a Mac.
- Observed behavior
- Excel ignores the requested number of copies and prints only the amount specified during the workbook's very first print job. The issue persists even if the file is opened on a different computer.
Ensure your macOS and printer drivers are fully up to date, although this specific issue is primarily related to an internal Excel bug rather than printer driver configurations.
Keep Excel Updated and Report the Bug
Because this is a known bug in certain versions of Excel for Mac (such as 16.88), updating the application or reporting it to Microsoft is the primary long-term solution.
This behavior is isolated to the application itself, meaning standard printer troubleshooting will not resolve it permanently. Microsoft regularly releases patches for known bugs in its Office updates.
Open Excel on your Mac and click on 'Help' in the top menu bar, then select 'Check for Updates' to ensure you have the latest patches installed.
Navigate to 'Help' > 'Feedback' within Excel to report the issue directly to Microsoft. Be sure to include your exact macOS and Excel version numbers in the report.
Export to PDF as an Alternative Printing Method
If an existing Excel file is permanently stuck on a specific number of copies, exporting it to a PDF allows you to bypass the Excel print dialogue entirely.
Save the Workbook Before the First Print
For newly created workbooks, saving the file to your drive before initiating the very first print job can sometimes prevent the copy-count bug from triggering.
Use WPS Office to Print Spreadsheets Flawlessly on Mac
Tired of encountering persistent printing bugs in Excel for Mac? Switch to WPS Office. It is a completely free, lightweight, and highly compatible alternative that handles your spreadsheet printing tasks effortlessly without locking your print settings.
- 1. Download the software: Visit the official WPS Office website and download the Mac installer.
- 2. Install and open: Run the downloaded installer and follow the on-screen prompts to set up WPS Office on your macOS device.
- 3. Print your files: Open your existing Excel spreadsheets in WPS Spreadsheets and print multiple copies reliably.
Frequently Asked Questions
Why does Excel for Mac only print one copy no matter what I select?
This is due to a known bug in certain versions of Excel for Mac (such as version 16.88). The application incorrectly retains the copy count from the very first time the workbook was printed, subsequently ignoring any future changes made in the print dialogue.
Will reinstalling my printer driver fix the Excel printing bug?
No. Testing and user reports show that this is an application-level bug within Excel itself, not a misconfiguration with your printer drivers. Updating Excel is the proper way to resolve it once Microsoft releases an official patch.
How can I print multiple copies of an existing Excel file that is stuck?
The most reliable workaround for an existing file is to export the workbook as a PDF by going to File > Save As > PDF. You can then open the resulting PDF file using your Mac's default Preview app, where you can freely adjust the number of copies in the print settings.
