Understanding the Two Page View Limitation
Excel 2013 introduced several viewing modes to help users manage complex worksheets and prepare documents for print. Among these, the Two Page View (accessed via View > Two Pages) is specifically engineered to show two adjacent pages as they would appear when printed. Unlike the standard Zoom or Split views, this mode locks the interface to prevent accidental modifications to the page layout while reviewing the document structure. Consequently, horizontal scrolling is intentionally disabled because the application assumes the user is only interested in the current pair of pages defined by the vertical page break.
This behavior can be frustrating when you need to copy data from one side of the screen to the other, especially if your data spans across multiple columns that are split between the two displayed pages. Users often expect a seamless browsing experience similar to reading a PDF or a web page, but Excel prioritizes print fidelity over navigational fluidity in this specific mode. If you find yourself unable to scroll horizontally, it is not a bug or a corrupted file state; it is a functional constraint of the Two Page View setting.
Switching to Normal View for Editing
The most straightforward solution to regain full control over scrolling and cell selection is to exit the Two Page View entirely. You can do this by navigating to the View tab on the Ribbon and selecting Normal. In Normal view, Excel displays the entire worksheet grid without imposing artificial page boundaries on the interface. This allows you to use the scroll bars freely, navigate to any cell using keyboard shortcuts like Ctrl+End, and copy-paste content between distant sections without restriction.
If you frequently toggle between viewing layouts and editing data, consider creating a custom shortcut or keeping the View tab accessible. Many power users keep the Page Layout view handy for checking margins and headers, but reserve Normal for all actual data entry and manipulation tasks. This separation of concerns helps maintain workflow efficiency and prevents the confusion caused by locked interface elements.
Using the Split Function for Multi-Section Access
If your goal is to compare data at opposite ends of a wide spreadsheet without leaving the editing environment, the Split feature is a superior alternative to Two Page View. To activate this, click anywhere in the middle of your dataset, then go to the View tab and select Split. This divides the window into four quadrants, allowing you to scroll each section independently while remaining in Normal view.
This method preserves all interactive capabilities, including horizontal scrolling, cell selection, and formula editing. It is particularly useful for reconciling data sets or copying information from a summary sheet to a detailed transaction log. Unlike the static nature of Two Page View, Split provides a dynamic workspace that adapts to your scrolling actions. For more advanced linking scenarios, you might also explore techniques for filling an Excel cell based on data in two other cells, which complements efficient multi-section workflows.
Adjusting Page Breaks Manually
Sometimes, the issue arises because the automatic page breaks are positioned inconveniently, forcing data onto separate pages in a way that complicates review. You can manually adjust these breaks by switching to Page Layout view. Here, you will see blue dashed lines indicating where Excel intends to break the pages. You can drag these lines to redefine how your content flows across printed sheets.
Once you have adjusted the breaks to suit your needs, you can return to Normal view to continue working. Note that even in Page Layout view, horizontal scrolling is typically enabled, but the interface may behave differently depending on the zoom level. If you encounter issues loading documents after changing view settings, ensure your file is not corrupted by checking for errors described in guides on Excel Won't Load Document on Double-Click scenarios.
Keyboard Shortcuts for Navigation
While in Normal view, mastering keyboard shortcuts can further enhance your productivity. Use Ctrl+Left, Ctrl+Right, Ctrl+Up, and Ctrl+Down to jump to the edges of data regions. For jumping to the very last used cell, Ctrl+End is indispensable. These shortcuts work reliably regardless of the zoom percentage or window size, providing a fast way to navigate large datasets without relying on mouse-driven scrolling.
Frequently Asked Questions
Why does my Excel file freeze when I try to scroll in Two Page View?
The view does not freeze; it simply restricts input to maintain the integrity of the page layout preview. Excel disables horizontal movement to prevent users from accidentally shifting content relative to the printed page boundaries. Exiting the view restores normal functionality immediately.
Can I enable horizontal scrolling within Two Page View permanently?
No, there is no native setting to enable horizontal scrolling in Two Page View because the feature is strictly for print preview purposes. You must switch to Normal or Page Layout view to interact with the grid freely. Any workaround would require external add-ins, which are generally discouraged for stability reasons.
What is the difference between Two Page View and Page Layout View?
Two Page View shows exactly two pages side-by-side for comparison, while Page Layout View shows the entire sheet with visible margins and breaks. Page Layout View allows scrolling and editing, whereas Two Page View locks the interface to prevent unintended changes to the print structure.
How do I copy cells from one page to another if scrolling is disabled?
You cannot directly select and drag across the gap in Two Page View. Instead, switch to Normal view, select the source range, copy it (Ctrl+C), navigate to the destination, and paste (Ctrl+V). Alternatively, use the Name Box to type the address of the far-off cell and press Enter to jump there instantly.
Does this issue occur in newer versions of Excel?
Yes, Microsoft has maintained this behavior in Excel 2016, 2019, and Microsoft 365. The Two Page View remains a static preview tool. However, newer versions offer improved performance and additional options for managing page breaks, but the fundamental restriction on scrolling in this specific view persists.