Validation drop down box too large
I have made drop down boxes for several columns in a workbook. The problem
is that the drop down box is too wide. For example, for a simple "Yes,No"
selection the drop down box is +/- 7 inches wide. Can I size the driop down
box to simply be the width of the column it is referring to? I have looked
everywhere, and in the process learned many things but have not found an
answer to my delemma. Any help would be greatly appreciated.
|