Printing Problems

Fix Excel Print Preview Showing a Large Blank Area

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 869 views

Question details

User needs to stop Microsoft Excel Print Preview from showing worksheet content far below the top of the preview pane when too many recent workbooks are configured in the Backstage view.

Fix Excel Print Preview Showing a Large Blank Area
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user opens Print Preview in Excel to check layout before printing and sees a large blank area above the worksheet.
Observed behavior
Worksheet content appears far below the top of the Print Preview pane when many recent workbooks are configured in the Backstage view.
Before you start

Close Print Preview and keep the affected workbook open. You only need to change the Excel Backstage display setting in File > Options > Advanced > Display.

Solution 1Recommended

Reduce Recent Workbooks Shown in Excel Backstage

Use this when Print Preview is offset by a long list of recent workbooks; lowering the number removes the large blank area.

Excel uses the recent-workbook count from the Backstage view when composing certain preview layouts. A high value can push worksheet content further down in Print Preview.

1
Open Excel Options

In Microsoft Excel, click File and then select Options.

2
Go to Advanced Display settings

In the Excel Options dialog, select Advanced and scroll to the Display section.

3
Lower the recent workbooks value

Find "Quickly access this number of recent workbooks" and reduce the value, for example from 20 to 6.

4
Apply and verify Print Preview

Click OK, reopen Print Preview, and confirm that the worksheet content is positioned correctly.

Reduce Recent Workbooks Shown in Excel Backstage
Preview position restored: Reducing the recent workbooks count changes the Backstage display and usually removes the blank area immediately.
Free Microsoft Office alternative

Open Excel Files in WPS Spreadsheet for a Cleaner Print Preview

WPS Office is a free, lightweight Microsoft Office alternative with familiar spreadsheet tools and strong .xlsx/.xls compatibility, so you can open the same workbook and use print preview without the Excel Backstage recent-workbook behavior.

  1. 1. Download WPS Office: Go to wps.com and download WPS Office for your Windows, macOS, Linux, or mobile device.
  2. 2. Open the workbook: Launch WPS Spreadsheet, click Menu or File, then open the .xlsx or .xls workbook.
  3. 3. Check Print Preview: Use the Print Preview option in WPS Spreadsheet to inspect the page layout before printing.
Avoids the Excel Backstage recent-workbook setting that can offset print previewFull compatibility with .xlsx, .xls, and other Microsoft Excel formatsFree and lightweight with a familiar ribbon-style spreadsheet interfaceSeamless migration from Microsoft Excel for editing, formatting, and printing
QA img-9

Frequently Asked Questions

Why is Excel Print Preview showing a large blank area at the top?

It is often caused by a high number of recent workbooks displayed in Backstage. Go to File > Options > Advanced > Display and reduce "Quickly access this number of recent workbooks".

Will reducing recent workbooks delete or affect my files?

No. The setting only controls how many recent workbook entries appear in the Backstage list; it does not delete or change workbook files.

Can I fix this by changing printer settings instead?

Usually not. This blank area is tied to the Excel Backstage recent-workbook display setting, not the printer driver or page setup.

Does WPS Spreadsheet have the same print preview blank area issue?

WPS Spreadsheet is not dependent on the Microsoft Excel Backstage recent-workbook list, so the same trigger is not present; you can open .xlsx files in WPS Office and use its print preview.