'%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)
Fix Excel Printing Worksheets on Separate Pages Instead of Duplex
Question details
The user needs to print multiple Excel worksheets on both sides of the paper (duplex printing), but the application is printing each worksheet on a separate sheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing multiple active worksheets simultaneously with two-sided (duplex) printing enabled.
- Observed behavior
- Each worksheet is printed on a separate physical page, ignoring the duplex intent across different sheets.
Ensure that your printer physically supports duplex (two-sided) printing and that you have tested printing on both sides from another application, such as Microsoft Word or a web browser, to rule out hardware issues.
Synchronize Page Setup and Duplex Settings Across Worksheets
Excel processes worksheets as separate print jobs if their individual page setups (like DPI, scaling, or orientation) do not match exactly. Standardizing these settings forces Excel to print them as a single duplex job.
When you group worksheets to print them together, Excel checks the Page Setup for each sheet. If it detects differences in print quality (DPI) or margins, it stops the current print job and starts a new one on a fresh piece of paper, breaking the duplex sequence.
Hold down the 'Ctrl' key on your keyboard and click the tabs of the worksheets you want to print at the bottom of the Excel window.
Go to the 'Page Layout' tab on the ribbon and click the small dialog box launcher arrow in the bottom-right corner of the Page Setup group.
In the Page Setup dialog, ensure that the Orientation, Scaling, Paper Size, and Print Quality are identical. Click 'OK' to apply these uniform settings to all grouped sheets.
Press 'Ctrl + P' to open the Print menu, ensure 'Print on both sides' is selected, and click the 'Print' button.
Clear Conflicting Print Areas
Custom print areas defined on individual worksheets can sometimes conflict with global print settings, causing pages to split unexpectedly.
Update the Printer Driver or Repair Microsoft 365
If Excel settings are correct but the issue persists, an outdated printer driver or a corrupted Microsoft 365 installation may be misinterpreting the duplex command.
Experience Seamless Printing with WPS Office
If Microsoft Excel continues to split your duplex print jobs despite correct settings, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly alternative to handle your spreadsheets efficiently without the printing headaches.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing Excel file. Your data and formatting will remain perfectly intact.
- 3. Print on Both Sides: Press Ctrl+P, select your duplex-enabled printer, choose your sheets, and print your workbook seamlessly on both sides.
Frequently Asked Questions
Why does Excel ignore my two-sided printing settings?
Excel treats worksheets with different page setups (such as different DPI, scaling, or margins) as completely separate print jobs. When a new print job is triggered, the printer automatically starts on a new sheet of paper, effectively ignoring the two-sided command for the transition between those sheets.
How can I check if my printer supports duplex printing?
Open any program like Word or your web browser, press Ctrl+P to open the print dialog, and look for an option titled 'Print on both sides' or 'Duplex Printing'. If the option is missing or grayed out across multiple applications, your printer or current driver does not support it.
Does saving the Excel file as a PDF fix the duplex printing issue?
Yes. If you go to File > Save As and select PDF, or use 'Microsoft Print to PDF', you can generate a single PDF document. Opening this PDF in a dedicated reader (like WPS PDF or Adobe Acrobat) allows you to easily print the entire document double-sided without Excel's per-worksheet interruptions.
