Formatting Issues

How to Fix Excel 365 Row Autofit Cutting Off Wrapped Text

Natalie TaylorNatalie Taylor Nov 4, 2026 870 views

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.

Fix Excel 365 Row Autofit Cutting Off Wrapped Text
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the affected cells

Click and drag to highlight the cells where the wrapped text is being cut off.

2
Open Format Cells

Right-click the selected area and choose 'Format Cells' from the context menu, then navigate to the 'Alignment' tab.

3
Toggle Wrap Text

Check the 'Wrap text' box. If it is already checked, uncheck it, click OK, and then repeat the process to re-check it.

4
Apply AutoFit

Go to the 'Home' tab on the ribbon, locate the 'Cells' group, click on 'Format', and select 'AutoFit Row Height'.

Re-enable Wrap Text and AutoFit Row Height
Check your results: Your text should now be fully visible without any cut-offs at the bottom border.
Try WPS Spreadsheet

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. 1. Open your file in WPS: Launch WPS Spreadsheet and open your existing Excel workbook.
  2. 2. Select the target cells: Highlight the cells or rows that contain cut-off text.
  3. 3. Enable Wrap Text: Navigate to the Home tab and click the 'Wrap Text' icon to ensure text wrapping is active.
  4. 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.
100% compatible with Microsoft Excel formats (.xlsx, .xls)Accurate AutoFit calculations for wrapped text and Alt+Enter line breaksLightweight and runs smoothly on any display or Remote DesktopFamiliar user interface for a zero-learning-curve transition
microsoft office alternative - wps office

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.