How to Restore Normal View and Fix Incorrect Page Breaks in Excel
Question details
The user needs to remove unusual page breaks, tiny page areas, or incorrect margins to restore the normal display of an Excel worksheet.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- The worksheet is displaying unusually, with tiny page areas or weird margins, likely due to incorrect print or view settings.
- Observed behavior
- The worksheet does not display normally, showing unusual page breaks, incorrect margins, or appearing restricted to tiny page areas.
Before changing the page layout, ensure that you haven't accidentally applied a specific print area that restricts the visible data. It is also helpful to check if the issue occurs in all worksheets or just a specific one.
Switch Back to Normal View for Editing
Use this method if your worksheet looks like it's split into printed pages and you just want to edit your data normally.
Often, a worksheet appears broken into tiny pages simply because the viewing mode has been changed to 'Page Break Preview' or 'Page Layout'. Switching back to 'Normal' view is the quickest way to restore the standard editing grid.
Look at the top ribbon in your Excel window and click on the 'View' tab.
In the 'Workbook Views' group on the left side of the ribbon, click on the 'Normal' button. This will exit Page Break Preview or Page Layout view and restore your standard grid.
Adjust Page Layout and Print Scaling Settings
Modify the page setup if you are preparing to print and the page breaks or margins are physically incorrect.
Easily Manage Page Breaks and Views with WPS Spreadsheet
WPS Office provides an intuitive interface for managing worksheet views and print settings, ensuring your data is always displayed exactly how you want it without formatting headaches.
- 1. Open your file in WPS Office: Launch WPS Spreadsheet and open your document.
- 2. Reset to Normal View: Go to the 'View' tab on the ribbon and click 'Normal' to instantly restore your standard workspace view.
- 3. Fix Printing Boundaries: To fix actual page breaks, go to the 'Page Layout' tab where you can easily adjust Margins, Orientation, Size, or reset the Print Area in one click.
Frequently Asked Questions
Why did my Excel sheet suddenly shrink into tiny pages?
This usually happens if you accidentally switch to 'Page Break Preview' or 'Page Layout' view combined with an incorrect scaling setting. Going to the View tab and selecting 'Normal' will restore the standard appearance.
How do I remove the dotted page break lines in Normal view?
Dotted lines appear after you visit the Print preview or Page Layout view to show where pages will break. To remove them, you can close and reopen the workbook, or go to File > Options > Advanced, scroll down to 'Display options for this worksheet', and uncheck 'Show page breaks'.
How can I reset all manual page breaks in my worksheet?
Go to the 'Page Layout' tab on the ribbon, click on 'Breaks' in the Page Setup group, and select 'Reset All Page Breaks'. This will remove any manually inserted breaks and restore the automatic page distribution based on your paper size.
Why is my Print Area only showing a small portion of my data?
A specific, restricted print area might have been set previously by you or another user. To clear it, navigate to the 'Page Layout' tab, click the 'Print Area' button, and choose 'Clear Print Area'. This allows all active data to be included when viewing page breaks or printing.
