Software

Ask something
Discussion Locked

Excel Cell Sizing With Dropdown Boxes

0 helpful
4 replies

by stuart.douglas

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I’ve inserted a dropdown box into an Excel spreadsheet using the form toolbar. I’m trying to get the dropdown to move and size with the cell I’ve placed it in. When I right click on the dropdown and go into format control/properties and try and select the “move and size with cells” option its greyed out and cant be selected. Why can’t I choose this option?

4 replies

by dklippert

The list boxes from the Forms toolbar can not be sized with the cell.
Control bar boxes can be sized, but they're controlled with macros

by dklippert

Here's a follow up. Create your input list in an unobtrusive place. Name it ? Select the range and go to Insert>Name Define.
Bring up the Control toolbar.
Hold down the Alt key while you draw the list box, if you want the box to conform to the cell.
Right click and choose Properties.
Locate ListFillRange and enter the Range name. Also add the address for the LinkedCell.
Close the Property box. Right click the Control and choose Format Control. Choose the Move and size with cells option. Click OK
Now close Design mode by clicking the Design mode icon on the Control toolbar.

This discussion is closed to new replies.