Automatically Expand Excel Cells and Text Boxes for More Text
Question details
The user needs worksheet cells and text boxes to expand automatically when more text is entered.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Additional text must remain visible in an Excel cell or text box without manually resizing the row or shape.
- Observed behavior
- Cells do not automatically show all wrapped text, and text boxes may remain fixed in size as content increases.
Identify whether the text is in a worksheet cell or a floating text box, because each object uses different sizing controls. Select the target cell, row, or text box before changing its formatting.
Use Wrap Text and AutoFit Row Height for Excel worksheet cells
Use this method when additional text is entered directly into a worksheet cell and the row needs to grow vertically.
Wrap Text displays the cell content on multiple lines, while AutoFit Row Height adjusts the row to show those lines. If the row height was previously set manually, AutoFit may need to be applied again after editing the text.
Select the cell or range, open the Home tab, and click Wrap Text in the Alignment group.
With the cell or range selected, open Home > Format > AutoFit Row Height. Excel expands the row so the wrapped text is visible.
If the text wraps too many times, select the column and choose Home > Format > AutoFit Column Width, or drag the column boundary to set a suitable width.
Resize an Excel text box to fit its text
Use this method when the content is inside a floating text box rather than a worksheet cell.
Automatically Fit Cell and Text Box Content in WPS Spreadsheet
WPS Spreadsheet provides Wrap Text and AutoFit Row Height for worksheet cells, plus text box settings that resize a shape to fit its content. Use these controls to keep longer text visible while editing Excel-compatible files.
- 1. Wrap cell text: In WPS Spreadsheet, select the cell or range, open the Home tab, and click Wrap Text in the Alignment tools.
- 2. Fit the row height: Select the affected row, open the Home tab, choose Format, and select AutoFit Row Height so all wrapped lines are visible.
- 3. Resize a text box: Right-click the text box, choose Format Object or Format Shape, open the Text Options or Text Box section, and enable the setting that resizes the shape to fit text.
- 4. Save in an Excel-compatible format: Open Menu or File > Save As and choose Excel 97-2003 (*.xls) or Excel 2007-365 (*.xlsx) when you need to share the formatted file with Excel users.
Frequently Asked Questions
Why does AutoFit Row Height not show all the text in an Excel cell?
First enable Home > Wrap Text for the cell. Then select the row and choose Home > Format > AutoFit Row Height. A manually fixed row height or merged cells can prevent AutoFit from working normally.
Can an Excel text box grow automatically when I type more text?
Yes. Right-click the text box, choose Format Shape, open Text Options and the text box settings, then enable Resize shape to fit text or the equivalent AutoFit option in your Excel version.
What is the difference between Wrap Text and AutoFit Row Height?
Wrap Text places long cell content on multiple lines within the cell. AutoFit Row Height changes the row size so those lines are visible; using both settings is usually necessary.
Does this work with Excel files opened in WPS Spreadsheet?
Yes. WPS Spreadsheet supports Excel .xlsx and .xls files and provides similar Wrap Text, AutoFit Row Height, and text box resizing controls. Review the layout after saving if the file contains complex shapes or merged cells.
