How to Fix Excel 365 Row Autofit Cutting Off Wrapped Text
Question details
Users experience wrapped text being cut off at the bottom of the cell in Excel 365, even after applying the row autofit feature.

- Product
- Excel 365
- Device & OS
- not provided
- Scenario
- Applying row autofit to cells containing wrapped text or manual line breaks created with Alt+Enter or CHAR(10).
- Observed behavior
- Parts of the text are hidden or cut off after autofitting, particularly when using Remote Desktop, display scaling, or non-default zoom settings.
Ensure your text does not contain hidden trailing spaces or extra blank lines at the end of the cell, as these can interfere with Excel's autofit height calculations.
Re-enable Wrap Text and AutoFit Row Height
Refreshing the wrap text property and forcing a recalculation of the row height is often the quickest way to resolve cell display errors.
Sometimes Excel caches cell dimensions incorrectly. Toggling the wrap text feature forces Excel to reassess the text length and apply the proper row height when AutoFit is triggered.
Click and drag to highlight the cells where the wrapped text is being cut off.
Right-click the selected area and choose 'Format Cells' from the context menu, then navigate to the 'Alignment' tab.
Check the 'Wrap text' box. If it is already checked, uncheck it, click OK, and then repeat the process to re-check it.
Go to the 'Home' tab on the ribbon, locate the 'Cells' group, click on 'Format', and select 'AutoFit Row Height'.

Adjust Excel Zoom and Display Scaling
Scaling issues, especially on Remote Desktop or with high-DPI monitors, can cause Excel's Autofit to miscalculate row heights.
Manually Adjust Row Height
When automatic calculation fails repeatedly due to manual line breaks (Alt+Enter), manual adjustment is the most reliable workaround.
Seamlessly Manage Wrapped Text with WPS Spreadsheet
Avoid frustrating text cut-offs. WPS Spreadsheet offers highly accurate row autofitting, ensuring all your wrapped text and manual line breaks are perfectly visible across all display scaling settings.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your existing Excel workbook.
- 2. Select the target cells: Highlight the cells or rows that contain cut-off text.
- 3. Enable Wrap Text: Navigate to the Home tab and click the 'Wrap Text' icon to ensure text wrapping is active.
- 4. AutoFit the rows: Double-click the bottom border of the row number on the left side, or go to Home > Rows and Columns > AutoFit Row Height to perfectly adjust the height.

Frequently Asked Questions
Why does Excel cut off text when printing even if it looks fine on screen?
This discrepancy occurs due to differences between your monitor's screen resolution (pixels) and your printer's resolution (DPI). To prevent this, try setting your display scaling to 100%, or manually increase the row height by a few extra pixels before printing.
Can merged cells be autofitted in Excel?
No, Excel's AutoFit feature natively ignores merged cells. If you apply AutoFit to a merged cell containing wrapped text, the row height will not expand correctly. You must either adjust the row height manually or unmerge the cells and use the 'Center Across Selection' alignment option instead.
Does using Alt+Enter (manual line break) cause autofit to fail?
Yes, manual line breaks created with Alt+Enter or the CHAR(10) formula can sometimes disrupt Excel's AutoFit algorithm. Excel may miscalculate the total height needed for the final line, requiring you to manually drag the row taller to see the last line of text.




