Combobox to fit the size of a cell

S

Stefan

How do I insert a combobox to exactly fit the size and
position of a single cell?

Stefan
 
L

Lotus123

Hold down the "ALT" key while you drag the combo box on the inside o
one single cell. Once done, Excel will auto-adjust the size of th
combo box to fit the single cell. You can also use this to make
combo box the exact size of two cells or more...just drag the "outline
to be the approximate size you want
 
Top