How to Fix Excel Online Autofit Row Height with Hidden Columns
Question details
Users need a way to stop Excel Online from calculating excessive row heights based on text wrapped inside hidden columns.

- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Viewing or editing SharePoint workbooks in Excel Online where columns containing wrapped text are hidden.
- Observed behavior
- Excel Online calculates the autofit row height by factoring in the text within hidden columns, causing rows to appear excessively tall. This issue does not reproduce in the desktop version of Excel.
Verify if the workbook displays correctly in the Excel desktop application, as this rendering issue is specific to the web engine of Excel Online.
Disable Text Wrapping Before Hiding Columns
Prevent hidden columns from expanding row heights by turning off the Wrap Text feature for the data.
Excel Online's web rendering engine factors in text wrapping from hidden columns when calculating autofit row height. By removing the text wrap property from these specific columns, Excel Online will no longer expand the row height to accommodate the hidden text.
Select the columns adjacent to the hidden ones, right-click the column headers, and click 'Unhide'.
Select the newly unhidden columns. Go to the 'Home' tab on the ribbon and click the 'Wrap Text' button to toggle it off.
Right-click the column headers again and select 'Hide'. The autofit row height will now function normally without expanding.

Set Fixed Row Heights Manually
Override the autofit behavior by manually specifying a fixed height for the affected rows.
Edit Spreadsheets Flawlessly with WPS Office
If Excel Online rendering bugs are disrupting your workflow, consider switching to WPS Office. It provides a highly compatible desktop application that accurately handles hidden columns, wrapped text, and autofit settings without web-based glitches.

Frequently Asked Questions
Why do my rows get so tall in Excel Online when columns are hidden?
Excel Online has a web-rendering limitation where it calculates autofit row heights based on the wrapped text inside hidden columns. The desktop version of Excel typically ignores hidden data when calculating row height.
Does freezing panes cause the autofit row height bug in Excel Online?
No, user testing shows that the Freeze Panes feature does not affect this specific autofit behavior. The issue is strictly triggered by how Excel Online processes wrapped text within hidden columns.
How can I permanently fix the row height issue in SharePoint workbooks?
Since this is a recognized web-rendering limitation in Excel Online, the best permanent fixes are disabling 'Wrap Text' on the data before hiding the columns, manually setting a fixed row height, or opening the file in a desktop spreadsheet application.




