How to Fix Scrambled Display and Clipped Text When Printing in Excel
Question details
The user needs to fix formatting anomalies, display glitches, and printing errors in Excel, such as scrambled layouts, missing rows, and text being cut off.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Preparing and printing a spreadsheet layout.
- Observed behavior
- Excel exhibits rendering glitches including duplicated row numbers, distorted layouts, incorrect margins, and text clipping in printouts.
Before altering your layout settings, ensure your printer is powered on with updated drivers installed, and save a backup copy of your current workbook.
Adjust Page Layout and Print Settings
Correct scaling, row height, and text wrapping settings to ensure all text fits cleanly on the printed page.
In many cases, text clipping occurs because the row height is static or the text extends beyond the defined print margins. Adjusting the layout elements explicitly for printing will often solve the issue.
Go to 'File' > 'Print' to view the print preview. Identify specifically which rows or texts are being cut off or missing.
Select the cells containing cut-off text, navigate to the 'Home' tab, and click the 'Wrap Text' button in the Alignment group.
Right-click the row number containing clipped text, select 'Row Height', and enter a larger value. Alternatively, double-click the boundary below the row number to AutoFit the height.
In the Print menu, scroll down to the scaling options and select 'Fit Sheet on One Page' or 'Fit All Columns on One Page' to prevent your data from overflowing onto extra pages.

Disable Hardware Graphics Acceleration
Turn off graphics acceleration to resolve scrambled displays and rendering glitches caused by incompatible graphics drivers.
Update Office and Disable Conflicting Add-ins
Ensure your software is up to date and disable third-party add-ins that might be interfering with Excel's display rendering.
Avoid Print Layout Issues with WPS Office
Tired of troubleshooting Excel display glitches and scrambled printouts? Try WPS Office. It provides flawless rendering, accurate print layouts, and seamless compatibility with Microsoft Excel formats—all for free.

Frequently Asked Questions
Why is the bottom of my text cut off when printing in Excel?
This usually happens when the row height is too small for the font size or text wrapping isn't properly adjusted. To fix it, select the row, go to the Home tab, click 'Wrap Text', and double-click the row boundary to AutoFit the height.
Why does my Excel spreadsheet look distorted or scrambled on my screen?
Scrambled displays are often caused by graphics driver conflicts or outdated Office software. You can usually resolve this by going to File > Options > Advanced, and checking 'Disable hardware graphics acceleration'.
How do I ensure my entire Excel sheet prints on one page?
Go to File > Print, look for the scaling dropdown menu at the bottom of the settings, and choose 'Fit Sheet on One Page'. You can also adjust your page orientation to Landscape to fit more columns comfortably.
Can Compatibility Mode cause printing and layout issues?
Yes, older Excel formats (.xls) might render differently in newer versions of Excel, leading to print layout discrepancies. Saving your workbook in the current .xlsx format can help stabilize the layout and prevent glitches.




