Fix Excel Print Preview Showing a Large Blank Area
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.

- 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.
Close Print Preview and keep the affected workbook open. You only need to change the Excel Backstage display setting in File > Options > Advanced > Display.
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.
In Microsoft Excel, click File and then select Options.
In the Excel Options dialog, select Advanced and scroll to the Display section.
Find "Quickly access this number of recent workbooks" and reduce the value, for example from 20 to 6.
Click OK, reopen Print Preview, and confirm that the worksheet content is positioned correctly.

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. Download WPS Office: Go to wps.com and download WPS Office for your Windows, macOS, Linux, or mobile device.
- 2. Open the workbook: Launch WPS Spreadsheet, click Menu or File, then open the .xlsx or .xls workbook.
- 3. Check Print Preview: Use the Print Preview option in WPS Spreadsheet to inspect the page layout before printing.

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.




