Printing Problems

Fix Extra White Space When Printing an Excel Worksheet

Adam DavisAdam Davis Nov 20, 2026 868 views

Question details

The user needs to remove excessive blank space at the top of a printed worksheet page.

Fix Extra White Space When Printing an Excel Worksheet
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing a worksheet that appears correctly arranged in Page Layout view.
Observed behavior
The second printed page has a large blank area at the top. Other worksheets print correctly.
Before you start

Open the affected worksheet and use File > Print to confirm where the blank space appears in print preview. Check whether other worksheets or workbooks show the same behavior.

Solution 1Recommended

Check and reset Excel worksheet page breaks

Use Page Break Preview and print settings to find layout choices that may be creating the blank area.

1
Inspect page breaks

Select View > Page Break Preview and inspect the break before the second page. Automatic breaks are shown as dashed lines; manual breaks are shown as solid lines.

2
Reset manual breaks

Go to Page Layout > Breaks > Reset All Page Breaks. This removes manual breaks but does not remove automatic breaks.

3
Adjust print settings

Under Page Layout, check Margins, Print Area, and Scale to Fit. Adjust them if necessary, then use File > Print to see whether the automatic break and blank space have changed.

4
Add a break if needed

Select the row below the desired break, then choose Page Layout > Breaks > Insert Page Break. Check File > Print again before printing.

Check and reset Excel worksheet page breaks
Automatic page breaks: Excel calculates automatic breaks from the paper size, margins, scaling, and worksheet content. Resetting breaks removes manual breaks only.
Free Microsoft Office alternative

Preview and Print Worksheets with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface and support for Excel files, making it easy to move existing worksheets into WPS Spreadsheets. You can review print settings there, although it does not repair Excel's printing behavior and layouts may differ between applications.

Preview worksheet pages and adjust print settingsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for a smoother transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the worksheet look correct in Page Layout view but print with blank space?

Print settings, page breaks, paper size, or workbook issues can affect the final layout. Check File > Print and View > Page Break Preview to inspect the affected page.

Can I delete an automatic page break in Excel?

You cannot delete an automatic break directly. Change settings such as margins, paper size, scaling, or the print area under Page Layout to change where Excel places it.

What does Reset All Page Breaks remove?

Page Layout > Breaks > Reset All Page Breaks removes manual page breaks from the worksheet. Excel continues to calculate automatic breaks.

What should I try if only one worksheet prints incorrectly?

Check its page breaks and print settings first. If the issue persists, use File > Open > Browse, select the workbook, and choose Open and Repair from the Open button's menu.