'%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 Duplex Printing Not Working for Multiple Copies in Excel
Question details
The user is unable to print multiple copies of a single-page document double-sided in Microsoft Office applications; instead, each copy prints on a separate sheet.
- Product
- Microsoft Excel and Office
- Device & OS
- Windows
- Scenario
- Attempting to save paper by printing multiple copies of a one-page document on both sides of a single sheet of paper.
- Observed behavior
- The printer outputs each copy on a separate sheet of paper, despite automatic duplex printing being enabled and working normally for multi-page documents.
Ensure your printer natively supports automatic double-sided (duplex) printing and that you have installed the latest printer drivers from the manufacturer's official website.
Adjust Collation and Windows Printer Preferences
Modify your Windows printer preferences to enforce duplex printing by default and adjust the collation settings in Office to prevent the software from separating the copies into distinct print jobs.
Microsoft Office sometimes treats multiple copies of a single page as separate, distinct print jobs when collation is enabled. By turning off collation, the printer receives the copies as a single continuous job, allowing the duplex hardware to print on both sides.
In Windows, go to Settings > Bluetooth & devices (or Devices) > Printers & scanners. Select your active printer and click 'Manage'.
Click 'Printing preferences'. Locate the 'Two-sided' or 'Duplex' printing option and set it to 'Automatic'. Click 'Apply' and 'OK'.
Open your document in Excel or another Office app and press Ctrl + P to open the Print menu. Look under the Settings section, click the 'Collated' dropdown, and change it to 'Uncollated'.
Enter the number of copies you need and click 'Print'. The copies should now print on both sides of the paper.
Duplicate the Content to a Second Page
If changing settings does not resolve the Office-specific limitation, manually duplicating your single page into a two-page document will force the printer to use both sides of the sheet.
Try WPS Office for Seamless Document Management
If Microsoft Office printing glitches and software limitations disrupt your workflow, consider switching to WPS Office. It is a free, lightweight, and user-friendly alternative that provides complete control over your print layouts.
- 1. Download the Installer: Visit the official WPS website and download the free WPS Office installation package.
- 2. Install the Software: Run the downloaded file and follow the brief on-screen instructions to set up WPS Office on your computer.
- 3. Open and Print: Open your existing Office documents natively in WPS Office and access the Print menu to customize your duplex settings easily.
Frequently Asked Questions
Why does duplex printing work for multi-page documents but not multiple copies of one page?
Office applications often send multiple collated copies of a single page to the printer spooler as distinct, individual one-page print jobs. Because each job is only one page long, the printer hardware processes them separately and outputs them on individual sheets of paper.
Will disabling the 'Collate' option fix my double-sided printing issue?
Yes, in many cases. Changing the print settings from 'Collated' to 'Uncollated' instructs the software to send all copies as a single continuous stream of data. The printer recognizes this as one large job and successfully applies the double-sided printing rule.
How do I save a two-sided printing preset in Windows?
Go to Settings > Printers & scanners, select your printer, and open Printing preferences. Configure the 'Two-sided' setting to Automatic. If your driver supports it, look for an 'Add/Remove Presets' or 'Save As' button, name your preset, and set it as the default configuration before clicking OK.
