http://www.contextures.com/exceltextboxformat.html
Use an Excel TextBox to add information on a worksheet, to help users get started.
In Excel 2007, you can set the TextBox to resize automatically, if the text or text size is changed.
In Excel 2010, the text wrapping can also be enable, when the resize is set to automatic.
This video shows how to manually change the Excel 2010 settings, or use a macro to change all the text boxes.
Link to this comment:
All Comments (0)