How to Fix Excel Display Problems with Freeze Panes and Wrap Text
Question details
Users need to resolve a display issue where text renders incorrectly when using specific formatting tools together in a spreadsheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Navigating and scrolling through large worksheets that utilize both the Freeze Panes and Wrap Text features simultaneously.
- Observed behavior
- Text inside cells positioned beside frozen panes appears fragmented, cut off, or completely missing.
Before proceeding with troubleshooting, save a backup copy of your current workbook to ensure no data is lost during testing.
Disable Hardware Graphics Acceleration and Update Excel
Resolving conflicts between Excel's rendering engine and your system's graphics drivers is the most effective way to fix text fragmentation issues.
Excel relies on your computer's graphics hardware to smoothly render complex visual layouts like frozen panes and wrapped text. If there is a compatibility issue with your drivers, the text may fail to display correctly when scrolling.
Open Excel and click on 'File' > 'Options'. Select 'Advanced' from the left menu. Scroll down to the 'Display' section, check the box for 'Disable hardware graphics acceleration', and click 'OK'. Restart Excel to apply the changes.
Navigate to 'File' > 'Account' (or 'Office Account'). Under Product Information, click 'Update Options' and select 'Update Now' to ensure you have the latest bug fixes from Microsoft.
Right-click the Windows Start button and select 'Device Manager'. Expand 'Display adapters', right-click your graphics card, and select 'Update driver'.

Test in Safe Mode and Rebuild the Workbook
Use Safe Mode to rule out third-party add-ins, and transfer your data to a new file to eliminate potential workbook corruption.
Try WPS Office for Bug-Free Spreadsheets
If Microsoft Excel continues to struggle with rendering frozen panes and wrapped text, consider switching to WPS Office. It offers a lightweight, highly compatible spreadsheet environment that smoothly handles complex cell formatting without performance drops or missing text glitches.
- 1. Install WPS Office: Download and install the free version of WPS Office on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet, go to 'Menu' > 'Open', and select your problematic Excel file.
- 3. Apply Formatting Smoothly: Navigate to the 'View' tab to use 'Freeze Panes' alongside wrapped text without experiencing any fragmented rendering.

Frequently Asked Questions
Why does wrapped text disappear when I scroll past a frozen pane?
This is typically caused by a rendering lag or glitch within Excel's graphics engine. The application struggles to redraw the wrapped text cells quickly enough when scrolling next to a fixed, frozen section of the worksheet.
How do I know if my Excel workbook is corrupted?
If the display issues only occur in one specific workbook while other files render perfectly with frozen panes, the file itself may be corrupted. Copying the data to a new blank workbook usually resolves this problem.
Will turning off Freeze Panes fix the missing text?
Yes, unfreezing the panes (by going to View > Window > Unfreeze Panes) will typically force the screen to refresh and restore the missing text, though you will lose the convenience of keeping your headers visible.
What should I do if the issue persists on multiple devices?
If the problem happens across different computers, it is likely a persistent software bug. Ask your Microsoft 365 administrator to open a support ticket in the Microsoft 365 admin center under Support > New service request.




