Printing Problems

How to Fix Excel Printing Some Worksheets Double-Sided

Ayan Masood Oct 9, 2026 868 views

Question details

The user needs to print an entire workbook consistently without individual worksheets switching between single-sided and double-sided printing.

How to Fix Excel Printing Some Worksheets Double-Sided

Product: Excel
Device & OS: not provided
Scenario: Printing an entire Excel workbook containing multiple worksheets.
Observed behavior: When printing the entire workbook, one worksheet prints single-sided while the remaining worksheets print double-sided due to conflicting sheet-level print settings.

Before you start

Before adjusting your print configurations, confirm that your printer physically supports automatic duplex (double-sided) printing and is properly connected to your computer.

Solution 1Recommended

Apply Consistent Print Settings Across All Worksheets

This is the most effective method, as Excel often retains distinct page setups and print configurations for individual worksheets. Grouping them ensures uniform settings.

Because Excel saves print settings on a per-worksheet basis, selecting 'Print Entire Workbook' alone may not override the individual duplex preferences saved on each sheet. You must group the sheets first to apply a universal setting.

Select all worksheet tabs

Right-click on any worksheet tab at the bottom of your Excel window and choose 'Select All Sheets' from the context menu. All tabs will turn white, indicating they are grouped.

Open the Print menu

Click on 'File' in the top-left corner of the ribbon, then select 'Print' from the sidebar.

Configure the print range

Under the Settings section, ensure the dropdown is set to 'Print Active Sheets' (since all sheets are currently active and selected).

Adjust duplex printing options

Locate the double-sided printing option in the settings list (e.g., 'Print One Sided' or 'Print on Both Sides'). Select your preferred uniform setting for the entire batch.

Print and save

Review the Print Preview to ensure formatting is correct, then click 'Print'. Once done, right-click a sheet tab and select 'Ungroup Sheets', then save your workbook to lock in the corrected settings.

Apply Consistent Print Settings Across All Worksheets

Save to Retain Settings: Saving your workbook immediately after adjusting these grouped settings will preserve the uniform print preferences, preventing the issue from reoccurring in the future.

Solution 2

Verify Individual Page Setup and Printer Preferences

Use this method if applying global settings does not override stubborn specific worksheet configurations controlled by native printer driver dialogues.

Print Excel Files Easily

Easily Manage Print Settings with WPS Spreadsheet

WPS Office offers a powerful, intuitive Spreadsheet tool that fully supports Microsoft Excel files. It simplifies batch printing, allowing you to easily configure single-sided or double-sided printing across an entire workbook without dealing with conflicting background settings.

1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel workbook.
2. Group your sheets: Right-click the sheet tabs at the bottom and choose 'Select All Sheets'.
3. Access Print settings: Go to 'Menu' > 'Print' (or press Ctrl+P) and ensure 'Active sheets' is selected.
4. Set universal duplex preferences: Click 'Properties' to set your desired double-sided or single-sided printing options uniformly, then click 'Print'.

Fully compatible with Microsoft Excel (.xlsx) formatsIntuitive Print Preview and global Page Setup optionsLightweight design ensures fast loading and seamless printingFree to download and use for daily office tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel save different print settings for different worksheets?

Excel is designed to allow each worksheet to have its own independent Page Setup. This is highly useful for complex workbooks where one sheet might require landscape orientation and another portrait, but it can unfortunately cause inconsistencies with duplex printing when you attempt to print the entire file at once.

How can I preview the entire workbook before printing?

Go to File > Print, and under the first Settings dropdown, select 'Print Entire Workbook'. You can then use the navigation arrows at the bottom of the Print Preview pane to scroll through every page of the document to ensure all pages are formatted consistently.

Does selecting all sheets change formatting permanently?

Selecting all sheets and modifying the print settings applies those changes to all the grouped sheets. If you save the file after making these changes, the new uniform print settings become the default for those specific sheets moving forward.

Document & File Issues