Fix Microsoft Excel Page Layout View Size and Display Problems
Question details
The user needs to correct unexpected page sizes, white bars, and blocked text displayed in Microsoft Excel Page Layout view.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The workbook displays incorrectly in Page Layout view, and the user wants to determine whether the cause is view settings, display scaling, add-ins, an outdated Office build, or workbook damage.
- Observed behavior
- Excel shows incorrect page dimensions, white areas, or text that appears blocked in Page Layout view.
Record the current Excel version, workbook name, and zoom percentage, then open the same file in Normal view to determine whether the problem is limited to Page Layout view.
Reset Excel views and zoom settings
Use this first when page dimensions or blocked content appear only in a particular worksheet view.
Switching views and restoring zoom can refresh Excel's display information without changing worksheet data.
Open the workbook in Excel, select the View tab, and click Normal in the Workbook Views group.
On the View tab, click Page Break Preview and then select Page Layout to refresh the worksheet display.
On the View tab, use the Zoom button and choose 100%, or adjust the zoom slider in the lower-right status bar.
Open the Page Layout tab, click Size, and select the paper size intended for the worksheet. Then check Margins and Orientation.
Check display scaling, add-ins, and Excel updates
Use this when the problem affects several workbooks or began after a Windows, Office, or add-in change.
Repair Office or isolate a damaged workbook
Use this when the display problem persists after view and display checks or occurs only in one workbook.
Use WPS Office to view and adjust Excel-compatible page layouts
WPS Office is a free, lightweight alternative for opening and editing spreadsheets when Microsoft Excel display problems persist. Its familiar interface supports common page layout, zoom, print, and worksheet controls while maintaining compatibility with Microsoft Excel XLS and XLSX files.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheet, select Open, and load the affected XLS or XLSX workbook.
- 2. Check view and page settings: Use the View tab to change the worksheet view and zoom, then use the Page Layout tab to review paper size, orientation, and margins.
- 3. Save in an Excel-compatible format: Select Menu > Save As, choose Excel 2007-365 Workbook (*.xlsx) or the required Excel format, and save a new copy.
Frequently Asked Questions
Why does Excel Page Layout view show white bars or incorrect page sizes?
The display can be affected by zoom, paper size, margins, Windows display scaling, add-ins, outdated Excel builds, or corrupted workbook view information. Check View > Zoom and Page Layout > Size first.
How do I reset Excel Page Layout view?
Select View > Normal, then View > Page Break Preview, and finally View > Page Layout. Set the zoom to 100% with View > Zoom or the status bar slider, then review Page Layout > Size and Margins.
Can an Excel add-in cause Page Layout display problems?
Yes. Start Excel with Windows+R and the command excel /safe. If the issue disappears, disable COM add-ins through File > Options > Add-ins, select COM Add-ins in the Manage list, and click Go.
What should I do if only one Excel workbook has the problem?
Test the workbook on another computer, then copy its worksheets into a new workbook by right-clicking a sheet tab and choosing Move or Copy > (new book) > Create a copy. A new file can remove damaged view information.
How can I repair Excel if display troubleshooting does not work?
Open Windows Settings > Apps > Installed apps, find Microsoft 365 or Microsoft Office, choose Modify, and run Quick Repair. If necessary, repeat the process with Online Repair.
