How to Stop Excel Cells from Expanding After Double-Clicking
Question details
The user wants to prevent Excel cells, rows, or columns from unexpectedly expanding or changing size when double-clicked.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Editing a spreadsheet where cells contain multiple lines of text or hidden formatting characters.
- Observed behavior
- When double-clicking a cell to edit, the row height or column width increases automatically, usually due to hidden manual line breaks and active wrap text settings.
Before altering your layout, check the Formula Bar for the affected cell to see if there is extra spacing or hidden text pushing the content downward.
Remove Manual Line Breaks and Disable Wrap Text
The most common cause of unexpected cell expansion is the combination of hidden manual line breaks and the Wrap Text feature being enabled.
When a cell contains a manual line break (created by pressing Alt+Enter), Excel treats it as a multi-line entry. If Wrap Text is also turned on, double-clicking the cell forces Excel to recalculate and expand the row height to display all lines.
Click once on the cell that expands unexpectedly when you try to edit it.
Navigate to the 'Home' tab on the top ribbon. Locate the 'Alignment' group and click 'Wrap Text' to toggle it off. This forces all text to remain on a single line.
Double-click the cell or click inside the Formula Bar. Use the Backspace or Delete key to remove any manual line breaks or excessive spaces at the end of the text.

Lock Row Height to Prevent AutoFit
If adjusting the text formatting does not resolve the issue, you can manually lock the row height so it stops expanding automatically.
Easily Manage Cell Formatting with WPS Spreadsheet
WPS Spreadsheet provides an intuitive interface to control cell alignment, wrap text, and row heights, ensuring your data displays exactly as intended without frustrating automatic resizing.
- 1. Open your file in WPS Office: Launch WPS Office and open your spreadsheet document.
- 2. Highlight the affected rows: Select the cells or entire rows that are expanding automatically when clicked.
- 3. Toggle Wrap Text: Navigate to the Home tab and click the 'Wrap Text' icon to disable it, instantly snapping your rows back to a uniform height.

Frequently Asked Questions
Why do my Excel rows get bigger when I type?
If the 'Wrap Text' feature is enabled, Excel automatically adjusts the row height to fit the newly typed content. Disabling 'Wrap Text' on the Home tab will keep the row height static.
How do I spot hidden line breaks in my spreadsheet?
You can spot manual line breaks by clicking a cell and expanding the Formula Bar by clicking the down arrow on its right side. Alternatively, use the Find and Replace dialog (Ctrl+H) and type Ctrl+J in the 'Find what' box to locate them.
Does double-clicking a cell border always expand it?
Yes, double-clicking the boundary line between row numbers or column letters triggers the AutoFit feature. This tells the spreadsheet program to automatically expand the row or column to fit the largest piece of content in that specific section.




