View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Depley Depley is offline
external usenet poster
 
Posts: 3
Default 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.