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


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=181581