Printing Problems

How to Fix Excel Printing Blank Rows or Missing Data

Ayan Masood Oct 22, 2026 868 views

Question details

The user needs to resolve an issue where certain rows in a large spreadsheet fail to print or appear blank in a PDF, even though the data is present in the document.

How to Fix Excel Printing Blank Rows or Missing Data

Product: Microsoft Excel
Device & OS: not provided
Scenario: Printing a large dataset to a physical printer or exporting it to a PDF document.
Observed behavior: The generated PDF or physical printout contains unexpected blank rows and missing data gaps that do not reflect the actual visible data in the electronic workbook.

Before you start

Ensure your printer drivers are up to date and verify that your workbook does not have a hidden font color applied to the seemingly blank rows.

Solution 1Recommended

Reset Page Breaks and Optimize Print Quality

Resetting manual page breaks and increasing the print quality settings often forces Excel to correctly render all rows and clears up data gaps.

Sometimes Excel's rendering engine skips rows when Draft mode is enabled or when page breaks become corrupted in large workbooks. Adjusting the Page Setup properties will force the software to recalculate the print area and output the document faithfully.

Reset Page Breaks

Go to the Page Layout tab on the ribbon. Click on 'Breaks' in the Page Setup group, and then select 'Reset All Page Breaks'.

Access Page Setup

Click on File in the top-left corner, select Print, and click on 'Page Setup' at the bottom of the settings menu.

Adjust Print Quality

In the Page Setup dialog box, go to the 'Page' tab. Locate the 'Print quality' drop-down menu and change it to the highest available DPI setting.

Disable Draft Quality

Switch to the 'Sheet' tab within the same dialog box. Uncheck the box for 'Draft quality' and consider checking 'Gridlines' to help force proper visual rendering before clicking OK.

Reset Page Breaks and Optimize Print Quality

Testing the Output: Use the Print Preview pane to visually inspect the pages before sending them to the printer to confirm the missing rows have returned.

Solution 2

Clear and Re-define the Print Area

A mistakenly configured or corrupted print area might exclude certain columns or rows from rendering correctly.

Solution 3

Change the Printer or PDF Driver

If the issue persists, the problem may lie with the specific printer driver or PDF software failing to interpret Excel's rendering instructions.

Free Microsoft Office alternative

Try WPS Office for Flawless Spreadsheet Printing

If Microsoft Excel continues to drop data during printing or PDF export due to persistent software or driver glitches, consider switching to WPS Office. WPS Spreadsheet is a free, lightweight alternative that flawlessly handles large files, maintains full format compatibility, and provides a highly stable printing engine to prevent missing rows.

1. Install WPS Office: Download and install the free WPS Office suite on your device.
2. Open Your Spreadsheet: Open your problematic Excel workbook directly in WPS Spreadsheet.
3. Print or Export without Errors: Go to Menu > Print or select 'Export to PDF' to generate perfect copies without missing rows.

Highly stable print engine that prevents missing data or blank rows during physical printing and PDF export.Seamlessly open, edit, and print Microsoft Excel formats (.xlsx, .xls) with zero data loss.Free, lightweight, and features a familiar user interface with no steep learning curve.Built-in, high-quality PDF exporter for perfectly formatted digital document sharing.

Frequently Asked Questions

Why are some rows randomly blank when I save my Excel file as a PDF?

This is often caused by Excel's rendering engine clashing with your PDF driver, especially when Draft Quality is enabled or print quality settings are set too low. Adjusting print quality to the highest DPI setting usually fixes this.

Will resetting page breaks affect my document formatting or delete data?

No. Resetting page breaks simply removes manually inserted breaks and returns the spreadsheet to its default automatic pagination. It does not alter, delete, or modify any actual data within your cells.

How do I know if the missing data problem is caused by my printer or Excel?

You can test this by changing your selected printer to a virtual PDF printer like 'Microsoft Print to PDF'. If the resulting digital PDF contains all the missing rows, your physical printer driver needs an update. If data is still missing in the PDF, the issue stems from Excel's print settings.

Document & File Issues