Excel Performance Problems

How to Fix Excel Online Autofit Row Height with Hidden Columns

Huda QurayshiHuda Qurayshi Nov 3, 2026 869 views

Question details

Users need a way to stop Excel Online from calculating excessive row heights based on text wrapped inside hidden columns.

How to Fix Excel Online Autofit Row Height with 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.
Before you start

Verify if the workbook displays correctly in the Excel desktop application, as this rendering issue is specific to the web engine of Excel Online.

Solution 1Recommended

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.

1
Unhide the affected columns

Select the columns adjacent to the hidden ones, right-click the column headers, and click 'Unhide'.

2
Disable Wrap Text

Select the newly unhidden columns. Go to the 'Home' tab on the ribbon and click the 'Wrap Text' button to toggle it off.

3
Re-hide the columns

Right-click the column headers again and select 'Hide'. The autofit row height will now function normally without expanding.

Disable Text Wrapping Before Hiding Columns
Formatting Retained: Disabling wrap text only affects the visual display of the hidden column data and does not delete any of your actual cell contents.
Free Microsoft Office alternative

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.

Flawless handling of row heights, hidden columns, and formatting.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight desktop app that runs smoothly without web browser limitations.Free to use with a familiar, user-friendly interface.
microsoft office alternative - wps office

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.