Printing Problems

How to Fix Excel Worksheet That Won't Print but Exports to PDF

Amos Gikunda Oct 9, 2026 869 views

Question details

The user is unable to print a specific Excel worksheet, although other sheets in the workbook print normally and the affected sheet can be successfully exported to a PDF.

How to Fix an Excel Worksheet That Won't Print but Exports to PDF

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to send a specific worksheet to a physical printer within a larger workbook file.
Observed behavior: The specific worksheet fails to print out, but saving or exporting the exact same sheet as a PDF file works perfectly.

Before you start

Before modifying your workbook, create a backup copy of your file to prevent any accidental data loss during the repair or troubleshooting process.

Solution 1Recommended

Adjust Print Settings and Verify Printer Selection

Verify your default printer and clear the worksheet's print area settings, which are common culprits for isolated printing issues.

Often, a specific worksheet holds onto outdated or conflicting page setup configurations that prevent it from communicating properly with the printer driver.

Select the correct printer

Press Ctrl+P to open the Print dialog box and ensure the correct default physical printer is selected in the dropdown, rather than a virtual PDF printer.

Clear the print area

Go to the Page Layout tab on the ribbon, click on Print Area, and select Clear Print Area to remove any invisible or conflicting print ranges.

Verify page setup

Click the dialog box launcher in the bottom-right corner of the Page Setup group to ensure scaling, margins, and paper sizes match your physical printer capabilities.

Adjust Print Settings and Verify Printer Selection

Alternative Printing Method: If direct printing still fails, try saving the workbook as an XPS file. You can then open the XPS file and print it, which often bypasses worksheet-level formatting blocks.

Solution 2

Use the Open and Repair Tool

Use Microsoft Excel's built-in repair tool to fix underlying data corruption within the specific worksheet.

Solution 3

Transfer Data to a New Workbook

If the worksheet remains corrupted and refuses to print, transfer the raw data into a brand-new workbook.

Seamless Spreadsheet Printing with WPS Office

Print Your Spreadsheets Effortlessly with WPS Office

If you are facing persistent printing errors or file corruption in your current spreadsheet software, WPS Office provides a highly compatible and stable alternative. You can easily open your existing files, adjust print layouts with a familiar interface, and print your worksheets instantly without hidden setting conflicts.

1. Open your workbook: Launch WPS Office and click on 'Spreadsheets'. Go to 'Menu' > 'Open' to seamlessly load your existing Excel workbook.
2. Adjust print settings: Navigate to the 'Page Layout' tab to quickly configure your print area, margins, and scaling without encountering formatting blocks.
3. Preview and print: Click 'Menu' > 'Print' or press Ctrl+P to access the intuitive print preview interface, select your default printer, and print your worksheet instantly.

Highly compatible with all Microsoft Excel formats including .xls and .xlsxBuilt-in PDF converter and stable, reliable printing engineFree, lightweight, and incredibly fast to install and useFamiliar ribbon interface for zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel worksheet export to PDF perfectly but refuse to print?

Exporting to PDF utilizes a built-in virtual rendering engine that often bypasses hardware-specific printer driver errors and strict physical margin limits. A corrupted print area or an outdated printer driver might block a physical print job while allowing a PDF export to succeed.

How do I clear a stuck print area in my worksheet?

To reset your print boundaries, navigate to the Page Layout tab on the top ribbon, click the Print Area button, and select Clear Print Area from the dropdown menu. This will prompt Excel to print the entire active worksheet.

Can saving as an XPS file help with stubborn printing issues?

Yes, saving the workbook as an XPS file acts similarly to a PDF export by creating a flattened, print-ready document. You can open the resulting XPS file in an XPS viewer and print it directly to your physical printer to bypass the Excel file corruption.

How can I recover data from a severely corrupted Excel worksheet?

You can use the 'Open and Repair' feature found in the File > Open dialog box. If that fails, create a new workbook and extract the data using external references (for example, typing '=[OldBook.xlsx]Sheet1!A1' into the new workbook) to retrieve values without copying the corrupted elements.

Document & File Issues