Frame/box to increase automatically to allow more text

Copper Contributor

When typing into a box, I need that box to automatically expand to accommodate the addl text.

1 Reply


In Excel, you can make a cell (or text box) automatically expand to accommodate additional text by enabling the "Wrap Text" feature and allowing the row or column to automatically adjust its height or width. Here's how to do it:

Method 1: Using a Cell (Wrap Text Option)

  1. Select the cell in which you want the text to automatically expand.
  2. Click the "Wrap Text" button on the Home tab of the Excel Ribbon. This button looks like a square with a diagonal arrow in it.
    • Enabling "Wrap Text" allows text to wrap within the cell, and when there's more text than can fit in the current cell size, the cell will automatically adjust its row height to accommodate the additional text.

Method 2: Using a Text Box (AutoFit Feature)

If you're using a text box (an object), you can enable the "AutoFit" feature to make it automatically expand. Here's how:

  1. Insert a text box by going to the "Insert" tab, then selecting "Text Box" from the "Text" group.
  2. Type or paste your text into the text box.
  3. Right-click on the text box and choose "Format Shape" or "Format Text Box," depending on your Excel version.
  4. In the Format Shape or Format Text Box pane, go to the "Text Box" section (or "Text Box Options" section, depending on your Excel version).
  5. Check the "Resize shape to fit text" or "AutoFit" option.
  6. Close the Format Shape pane.

Now, as you type or paste additional text into the text box, it will automatically expand to accommodate the extra content.

Choose the method that best suits your needs, whether it's working directly in a cell or using a text box to insert and manage your text. The text was created with the help of AI.


My answers are voluntary and without guarantee!


Hope this will help you.


Was the answer useful? Mark as best response and like it!

This will help all forum participants.