Cell with formula won't expand to fit text

**bejboutwell** · 03-31-2009, 02:56 PM

I have a cell set up with a formula to copy the content from another cell. However, the cell won't expand to fit the text. If you delete the formula and just type in the cell, it does expand.
See attachment.
Any help is appreciated! Thank you!

**shg** · 03-31-2009, 03:02 PM

The text is wrapped; you need to autofit the row height on sheet 2. It won't do it by itself.

**bejboutwell** · 03-31-2009, 03:08 PM

That only seems to work when you do it afterwards, is that correct?

**shg** · 03-31-2009, 03:20 PM

Correct ...

**bejboutwell** · 03-31-2009, 03:21 PM

Thanks for your help!

**shg** · 03-31-2009, 03:41 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes