How to lock a textbox in one direction?

rizzo93

Board Regular
Joined
Jan 22, 2015
Messages
222
I have a textbox on a worksheet that I want to autosize, but ONLY vertically.

I see in its properties the option for AutoSize, but this will adjust the box both horizontally and vertically.

How can I lock its width?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,090,554
Messages
5,415,252
Members
403,573
Latest member
stdar2

This Week's Hot Topics

Top