Fix Excel Online AutoFit Row Height Showing Only One Line
Question details
Users experience an issue in Excel Online where cells with wrapped text only display a single line, and AutoFit stops functioning correctly after cell editing.

- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Editing cells containing multiple lines of text in the web-based version of Excel.
- Observed behavior
- The cell collapses to show only one line instead of auto-fitting the row height to reveal all wrapped text.
Verify that your browser is up to date and that the 'Wrap Text' feature is currently enabled for the problematic cells.
Change Cell Format to Text and Reapply AutoFit
This is the most effective method to ensure Excel Online correctly recognizes and fits multiple lines of text within a cell.
Excel for the web sometimes struggles to dynamically calculate row heights when the cell format is set to 'General'. Changing the format to 'Text' forces the application to treat the contents purely as text strings, resolving the rendering glitch.
Click and drag to highlight the cells or entire rows that are only displaying a single line of text.
Navigate to the 'Home' tab. In the Number group, click the dropdown menu (which usually says 'General') and select 'Text'.
In the Alignment group on the 'Home' tab, make sure the 'Wrap Text' button is highlighted.
Move your cursor to the row numbers on the left. Hover over the bottom boundary of the affected row until a double-headed arrow appears, then double-click to automatically adjust the row height.

Toggle the Wrap Text Feature
If the row height collapses immediately after editing the cell content, toggling the Wrap Text feature can force Excel Online to refresh the display.
Manually Set the Row Height
When AutoFit completely fails to trigger in the web browser, manually dragging the row height provides an immediate, static workaround.
Experience Flawless Formatting with WPS Office
Tired of web-based spreadsheet glitches? WPS Office provides a powerful, free desktop alternative to Microsoft Excel. Enjoy perfectly wrapped text, seamless AutoFit, and offline stability without frustrating formatting bugs.

Frequently Asked Questions
Why does my row height not adjust automatically in Excel Online?
Excel Online can sometimes experience rendering issues or syncing delays with the 'General' number format in web browsers. Changing the cell format to 'Text' often forces the web app to recalculate and display the correct height.
Is there a keyboard shortcut to AutoFit row height?
In the desktop version of Excel, you can press Alt + H, then O, then A to AutoFit the row height. However, in Excel Online, web browser shortcut conflicts mean it is usually faster to double-click the row boundary.
Does Wrap Text work differently in Excel for the Web compared to Desktop?
While the core function is the same, Excel for the Web relies on browser rendering. This can sometimes cause visual bugs, such as collapsing to one line after pressing Enter, which are far less common in the native desktop application.




