Formatting Issues

Fix Excel Online AutoFit Row Height Showing Only One Line

Rana GarciaRana Garcia Nov 4, 2026 871 views

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.

How to Fix Excel Online AutoFit Row Height Showing Only One Line
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.
Before you start

Verify that your browser is up to date and that the 'Wrap Text' feature is currently enabled for the problematic cells.

Solution 1Recommended

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.

1
Select the affected cells

Click and drag to highlight the cells or entire rows that are only displaying a single line of text.

2
Change number format

Navigate to the 'Home' tab. In the Number group, click the dropdown menu (which usually says 'General') and select 'Text'.

3
Ensure Wrap Text is active

In the Alignment group on the 'Home' tab, make sure the 'Wrap Text' button is highlighted.

4
Trigger AutoFit

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.

Change Cell Format to Text and Reapply AutoFit
Formatting applied: Once the format is set to Text, subsequent edits in the cell are less likely to collapse the row height again.
Free Microsoft Office alternative

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.

Flawless text wrapping and dynamic AutoFit row height functionality.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight desktop application ensuring smooth performance with no web-sync lag.Familiar, easy-to-use interface that requires no learning curve.
microsoft office alternative - wps office

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.