Excel Performance Problems

Fix Excel Worksheet Disappearing or Jumping to Far-Right Columns

Natalie Taylor Oct 15, 2026 868 views

Question details

The user needs to resolve a display glitch in Microsoft 365 Excel where the worksheet content suddenly vanishes or jumps unexpectedly to the right.

Fix Excel Worksheet Disappearing or Jumping to Far-Right Columns

Product: Microsoft 365 Excel
Device & OS: not provided
Scenario: Scrolling, navigating, or editing within an Excel workbook that has frozen panes enabled.
Observed behavior: The worksheet displays a blank gray screen, or the view abruptly jumps to the far-right columns. Adjusting the zoom level only temporarily restores the proper view.

Before you start

Ensure you have saved your current workbook to prevent any accidental data loss. It is also recommended to check if Microsoft 365 recently installed a background update, as this is a common trigger for sudden display anomalies.

Solution 1Recommended

Adjust Zoom and Unfreeze Panes

Use this quick workaround to instantly regain visibility of your worksheet data without needing to restart the application.

Because this specific display glitch is closely tied to the Freeze Panes feature and the Excel rendering engine, altering the zoom level forces the screen to refresh. Removing the frozen panes entirely will stop the erratic jumping behavior.

Adjust the zoom level

Locate the zoom slider at the bottom right corner of the Excel window. Click the minus (-) or plus (+) buttons to slightly zoom in or out, which forces the gray screen to refresh and display your cells.

Navigate to the View tab

Click on the 'View' tab located in the top ribbon of the Excel interface.

Unfreeze the panes

Click on 'Freeze Panes' in the Window group, then select 'Unfreeze Panes' from the dropdown menu to prevent the worksheet from jumping to the far-right columns again.

Temporary Fix: This method acts as a temporary workaround. If you require frozen panes for your workflow and the issue persists, you will need to perform an Office repair.

Solution 2

Perform an Online Repair of Microsoft 365

A deep repair can fix corrupted installation files that cause persistent display bugs after a Windows or Office update.

Free Microsoft Office alternative

Avoid Excel Display Glitches with WPS Office

If Microsoft 365 continues to glitch or display a gray screen, consider switching to WPS Office. It is a highly stable, lightweight alternative that handles complex spreadsheets and frozen panes flawlessly while maintaining strict format compatibility.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Install the software: Run the downloaded installation package and follow the brief on-screen instructions to set up WPS Office.
3. Open your workbook securely: Launch WPS Spreadsheets and open your existing Excel file to continue working smoothly without display errors.

Stable rendering engine with no frozen pane display glitches100% compatible with Microsoft Excel formats including .xlsx, .xls, and .csvLightweight installation that opens massive workbooks quickly without crashingFamiliar user interface requiring zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel screen turn completely gray?

A gray screen in Excel is typically caused by graphics hardware acceleration conflicts or a bug in a recent Microsoft 365 update, particularly when the rendering engine struggles to display frozen panes.

Will unfreezing panes permanently fix the jumping columns?

Unfreezing panes stops the immediate jumping behavior and makes the worksheet usable, but it is considered a workaround. To permanently resolve the underlying bug, you may need to run an Online Repair or wait for the next Microsoft Office patch.

How can I check my current Microsoft 365 version to report the bug?

Open Excel, click on 'File' in the top-left corner, and select 'Account' at the bottom of the left menu. Your version, build number, and update channel will be clearly displayed under the 'About Excel' section.

Excel & Data Problems