How to Print Both Sides of an Excel Worksheet Correctly
Question details
The user needs to successfully print both sides of an Excel worksheet without losing content or omitting subsequent sheets.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to print an Excel workbook on both sides of the paper (duplex printing).
- Observed behavior
- Only the first worksheet prints, or text located farther down the sheet is omitted during two-sided printing due to incorrect print configurations.
Verify whether you are using the desktop version of Excel or Excel for the web, as the printing interfaces differ slightly. Additionally, ensure your physical printer supports automatic duplex (two-sided) printing and has enough paper loaded.
Clear and Reset the Print Area
Missing text or omitted pages during double-sided printing are frequently caused by an incorrectly restricted print area.
If a specific print area was previously saved in the document, Excel will only send those specific cells to the printer, ignoring the rest of the worksheet and preventing full double-sided printing.
Open your Excel workbook and click on the 'Page Layout' tab located in the top ribbon.
Click on 'Print Area' in the Page Setup group, then select 'Clear Print Area' from the drop-down menu to remove any restrictions.
If you only want to print a specific section, highlight the exact cells you wish to print, click 'Print Area', and select 'Set Print Area'.
Configure Duplex Printing and Workbook Selection
Make sure Excel is instructed to print the entire workbook and that the printer settings are properly configured for two-sided printing.
Easily Print Double-Sided Spreadsheets in WPS Office
WPS Spreadsheet provides an intuitive print preview and layout manager, making it simple to set print areas, scale your content to fit one page, and print on both sides effortlessly.
- 1. Open the workbook: Launch WPS Spreadsheet and open your document. Press 'Ctrl+P' or click the 'Print' icon in the quick access toolbar.
- 2. Select your printer: In the Print dialog box, select your duplex-capable printer from the 'Name' drop-down list.
- 3. Configure duplex settings: Check the 'Duplex' option located in the printer properties or the main dialog, and choose either long-edge or short-edge binding.
- 4. Define print range and execute: Under 'Print what', choose 'Entire workbook' or 'Active sheet', ensure scaling is correct, and click 'Print'.
Frequently Asked Questions
Why is my Excel sheet only printing on half the page when doing double-sided?
This usually happens because scaling is not enabled or the print area is manually restricted. Go to File > Print, and under the Scaling options at the bottom of the settings, select 'Fit Sheet on One Page' or adjust the Print Area under the Page Layout tab.
How do I print multiple worksheets double-sided at once?
Hold the Ctrl key and click the tabs of the specific worksheets you want to print at the bottom of the screen to group them. Then go to File > Print, ensure 'Print Active Sheets' is selected, and enable 'Print on Both Sides'.
What if my printer doesn't support automatic duplex printing?
If your printer lacks automatic double-sided printing, you can select 'Manual Print on Both Sides' in the Excel print settings. Excel will print all the odd pages first, then prompt you to flip and reload the paper to print the even pages.
Why is the 'Print on Both Sides' option greyed out in Excel?
The option may be greyed out if your selected printer does not physically support duplex printing, or if the printer driver needs to be updated. Check your printer properties in the Windows Control Panel to ensure the duplex unit is installed and enabled.
