Linking a text box to a cell so that the cell size expands when the text box gets bigger

Question

Is it possible to link a text box to a cell in excel so that the cell (or cells) expand or decrease with the text box?

Answer 1

Hi @LiChongWalling-5823

Welcome to the Microsoft Q&A forum and thank you so much for reaching out. 

I know how important it is to keep your Excel layout clean and flexible, especially when you're working with text that grows or changes over time. 

At the moment, Excel doesn’t include a built‑in feature that lets a text box automatically resize the underlying cell or range as you type or stretch the shape. I completely understand how useful that would be, especially for forms, dashboards, and templates where layout consistency matters. 

That said, there are a couple of reliable approaches depending on what you’re trying to achieve: 

Option 1: Make the text box follow the cells 

If you mainly want the text box to stay aligned with the cells while you resize rows or columns, Excel can already do that: 

1. Right‑click the text box 
2. Select Format Shape 
3. Go to Size & Properties > Properties 
4. Choose Move and size with cells 

This keeps everything aligned, but the shape doesn’t actively change the size of the cells. 

Option 2: Use a small macro to sync cell size to the text box 

If what you want is: “When I resize the text box, the cell area underneath should resize to match” this is possible with a short VBA macro. 

After adding it once, you can resize the text box however you like and simply click the shape to update the cells below it. If this sounds useful, I’m happy to provide the exact macro code and step‑by‑step setup. 

Option 3: Use wrapped cells instead of a text box 

If your goal is simply for the text to expand naturally, using normal cells with Wrap Text turned on may offer a cleaner and more predictable experience. I can also share a workaround if you’re using merged cells, as Excel doesn’t auto‑fit them by default. 

As a forum moderator, I hope you understand that I don’t have the ability to modify or escalate product issues directly. However, I strongly recommend submitting your feedback through the Microsoft 365 Feedback Hub .This is the most effective way to ensure your voice reaches theproduct team and can be considered for future improvements. 

Once you've submitted your feedback, feel free to share the link here in the comments. I’ll be happy to upvote it to help bring more visibility.   

Additionally, since many other users have expressed similar concerns but may not know where to submit feedback, if my response has helped you better understand the situation and guided you toward a possible next step, please mark it as the "Accepted Answer". Your action will help pin this post to the top, making it easier for others in the community who are experiencing the same issue to find your feedback and support it.   

Thank you again for your time and for raising this important usability concern.     

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

 

Answer 2

No. Excel does not support dynamically resizing worksheet rows/columns based on the size of a text box or shape.

What is possible is the reverse: linking the contents of a cell to a text box or shape so the text shown in the object updates when the cell changes. For example:

1. Insert a text box (Insert → Text → Text Box) or a shape.
2. Select the text box/shape.
3. Click in the formula bar, type = and then click the cell to link to (for example =Sheet1!F2).
4. Press Enter.

Now the text in the text box follows the cell’s value, but the cell’s size will not change when the text box is resized, and there is no built‑in way to make row height/column width automatically follow the text box dimensions.

---

References:

• Dynamically display the contents of a cell or range in a graphic object
• Link a chart title, label, or text box to a worksheet cell
• Add a text box to a chart
• Add a label or text box to a worksheet