Office Settings & Configuration

How to Fix Excel Selecting Multiple Cells in Page Layout View

Bushra Parveen Oct 1, 2026 869 views

Question details

Users experience an interface glitch where clicking a single cell causes multiple cells to be highlighted.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Editing a workbook while displaying the document in Page Layout view.
Observed behavior: Excel erroneously selects all cells below the one clicked. The issue affects specific documents and may temporarily resolve when zooming in/out or switching pages.

Before you start

Before attempting to report the issue, verify if the problem persists across all workbooks or if it is isolated to a specific corrupted file.

Solution 1Recommended

Use View and Zoom Workarounds

Quickly reset the display rendering to temporarily stop Excel from selecting multiple cells.

Since this is an interface rendering bug in Microsoft Excel, forcing the application to redraw the screen can often serve as a temporary fix.

Switch to Normal View

Navigate to the 'View' tab on the top Excel ribbon and click 'Normal' in the Workbook Views group. You can then switch back to 'Page Layout' to see if the issue is cleared.

Adjust the Zoom Level

Use the Zoom slider located in the bottom-right corner of the Excel window. Zooming in or out forces Excel to refresh the page layout.

Switch Worksheet Tabs

Click on a different sheet tab at the bottom of the workbook, then click back to your original sheet to refresh the active view.

Solution 2

Report the Bug to Microsoft Support

Submit a bug report to Microsoft to help developers prioritize and release a permanent patch.

Free Microsoft Office alternative

Experience Stable Spreadsheet Editing with WPS Office

If display bugs like the Page Layout selection glitch in Microsoft Excel are disrupting your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible, and stable spreadsheet alternative for free.

1. Download the Installer: Visit the official WPS Office website and download the free version for your operating system.
2. Install WPS Office: Run the setup file and follow the quick on-screen instructions to complete the installation.
3. Open Your Spreadsheets: Right-click any Excel file, select 'Open with', and choose WPS Spreadsheets to start editing without bugs.

Seamlessly open, edit, and save Microsoft Excel (.xlsx, .xls) files with excellent compatibility.Enjoy a stable editing environment free from Page Layout rendering glitches.Lightweight application that runs smoothly even on older devices.Familiar ribbon-style interface that requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel highlight multiple cells when I only click one?

This is a known rendering bug in Microsoft Excel that occasionally happens in Page Layout view. The software fails to correctly calculate the mouse pointer's position relative to the grid, resulting in a continuous selection of cells below the clicked area.

Is there a permanent fix for the Page Layout selection issue?

Currently, this is a software bug that requires an official update from Microsoft. Ensuring your Office installation is fully updated via File > Account > Update Options is the best way to receive the patch once released. In the meantime, use the zoom or view-switching workarounds.

How do I find my Excel version to include in a bug report?

Open Excel and click on 'File' in the top left corner. Select 'Account' (or 'Help' in older versions). Look under the 'Product Information' section on the right side to find your exact version number and build details.

Office App Problems