Formatting Issues

How to Prevent Excel for the Web from Expanding Rows After Alt+Enter

Aamir Naveed Akram Oct 22, 2026 868 views

Question details

The user wants to prevent Excel for the web from automatically turning on Wrap Text and increasing row height when inserting manual line breaks with Alt+Enter.

How to Prevent Excel for the Web from Expanding Rows After Alt+Enter

Product: Excel for the Web
Device & OS: not provided
Scenario: Organizing multiline text within a single cell using Alt+Enter to view via the formula bar, without altering the visual grid layout.
Observed behavior: Excel for the web automatically enables Wrap Text and expands the row height to fit the new lines every time the cell is edited, overriding previous manual sizing.

Before you start

Keep in mind that Excel for the web currently lacks a global setting to permanently disable auto-expanding rows for manual line breaks. You will need to apply row formatting manually to override this default behavior.

Solution 1Recommended

Set a Fixed Row Height Before Editing

Manually assigning a fixed row height before adding multiline text prevents Excel from automatically resizing the row when you use Alt+Enter.

Excel is designed to auto-fit rows to accommodate line breaks unless a custom row height has been explicitly set beforehand. By defining the row height first, Excel prioritizes your manual adjustment over its automatic auto-fit behavior.

Select the target row

Click on the row number on the left side of the screen to select the entire row where you plan to enter multiline text.

Adjust the row height

Right-click the row number and select 'Row Height' from the context menu. Enter your desired height value (e.g., 15) and click 'OK'.

Enter your data

Double-click the cell, type your text, and use Alt+Enter to insert line breaks. The row height will remain fixed at your specified value.

Consistent Grid Layout: Setting a fixed height ensures the spreadsheet layout remains uniform, and you can comfortably read the hidden multiline text using the formula bar at the top.

Solution 2

Manually Toggle Off Wrap Text

If you have already edited a cell and the row has unexpectedly expanded, you can manually disable the Wrap Text feature to restore standard formatting.

Free Microsoft Office alternative

Enjoy Precise Formatting Control with WPS Spreadsheet

If Excel for the web's automatic resizing disrupts your workflow, try WPS Office. As a fully featured, lightweight alternative, WPS Spreadsheet offers exact control over row heights, text wrapping, and line breaks without forcing unexpected layout changes.

1. Download and Install: Download WPS Office for free from the official website and follow the easy installation steps.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx files with complete formatting compatibility.
3. Edit Without Interruptions: Use Alt+Enter to organize your data. Enjoy stable row heights and complete formatting control tailored to your preferences.

Highly compatible with Microsoft Excel (.xlsx, .xls) filesStrict enforcement of fixed row heights and cell formattingFamiliar, easy-to-use interface with zero learning curveFree to use, lightweight, and fast on all devices

microsoft office alternative - wps office

Frequently Asked Questions

Why does Alt+Enter change the row height in Excel for the web?

Using Alt+Enter inserts a manual line break into a cell. By default, Excel auto-fits the row height to ensure all lines of text remain visible. This triggers an automatic expansion unless a custom row height has already been explicitly defined.

Can I permanently turn off auto-expanding rows in Excel for the web?

Currently, Excel for the web does not offer a global settings toggle to disable auto-expanding rows. Setting a fixed row height manually is the most reliable workaround to maintain uniform cell heights.

How can I read multiline cell content if the row height is fixed?

When a cell's height is restricted, you can select the cell and look at the formula bar located at the top of the spreadsheet interface. The formula bar can be expanded to comfortably scroll through and edit multiple lines of text.

Does this auto-expansion issue happen in the Excel desktop app?

While the desktop version of Excel also tries to auto-fit text by default, it generally respects manually set fixed row heights more consistently than the web version during subsequent edits.

Document & File Issues