'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Return Excel from Page Break Preview to Normal View
Question details
The user needs to exit Page Break Preview and return their worksheet to the standard Normal View.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing or editing a worksheet that is currently stuck displaying page breaks, blue borders, and page numbers.
- Observed behavior
- Excel is displaying the worksheet in Page Break Preview layout instead of the standard continuous grid.
Ensure your workbook is not actively processing a heavy print job, as changing layout views can occasionally lag or become temporarily unresponsive during printing operations.
Use the View Tab in the Ribbon
The most straightforward way to change your workbook view is through the primary View menu on the top Ribbon.
The Ribbon interface provides a dedicated View tab that controls how your document is displayed. Selecting the Normal option here immediately overrides any print-preview or page-break settings applied to the screen.
Look at the top Ribbon menu in your Excel window and click on the 'View' tab.
In the 'Workbook Views' group on the far left, click on the 'Normal' button. The worksheet will instantly return to the standard grid layout.
Use the Status Bar View Shortcuts
For a quicker switch without navigating away from your current Ribbon tab, use the view icons located at the bottom of the window.
Dismiss Page Break Selection with the Esc Key
If you are actively adjusting blue page break lines and the interface feels locked, clearing the current selection may help.
Easily Manage Worksheet Layouts with WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive interface for managing your workbook views. You can easily switch between Normal View, Page Layout, and Page Break Preview exactly as you would in Microsoft Excel, making your workflow completely seamless.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet that is stuck in Page Break Preview.
- 2. Navigate to the View menu: Click on the 'View' tab located on the top ribbon of the application.
- 3. Click Normal View: Select the 'Normal' icon on the left side of the toolbar to restore your standard grid view immediately.
Frequently Asked Questions
Why did my Excel sheet suddenly change to Page Break Preview?
This usually happens if you or someone else accidentally clicked the Page Break Preview icon on the bottom right status bar. Alternatively, if a colleague saved and shared the file while they were in Page Break Preview, Excel remembers that view state when you open the file.
How can I remove the dotted page break lines in Normal View?
After switching back to Normal View, you might still see dotted lines indicating where pages will break. To hide them, go to File > Options > Advanced, scroll down to the 'Display options for this worksheet' section, and uncheck 'Show page breaks'.
Can I set Normal View as the default for all worksheets?
Excel inherently defaults to Normal view for new blank workbooks. However, for existing files, Excel saves the view that was active when the document was last closed. You must manually switch to Normal View and save the document to keep that view as the default for that specific file.
Why are my View buttons greyed out?
The View buttons might be greyed out if you are actively editing a cell's contents (your cursor is blinking inside the cell) or if multiple sheets are grouped. Press 'Enter' or 'Esc' to finish editing, or right-click a sheet tab and select 'Ungroup Sheets' to re-enable the View options.
