AutoSizing TextBox

[Price]

I desire to create a collection of merged cells (say 5 cells), or a
textbox, which will wordwrap and grow (or autosize) so that all text
is seen on the sheet.

Can anyone assist with instructions on this?

 

[Tom Ogilvy]

right click on your text box and under format textbox, on the alignment tab,
you can set it to autosize by checking automatic size. This is a textbox
from the Drawing Toolbar.