Thread: Drop Box Width
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FloMM2 FloMM2 is offline
external usenet poster
 
Posts: 207
Default Drop Box Width

JDH,
If I understand you correctly, the drop down boxes is wider than the column
you are selecting iteems from a validation list.

That being said, try this:
Select a cell in the column with the drop down box. Do not make a selection
from list.
Select "Data" from the menubar.
Select "Validation".
In the "Source" section, you will find the source of your validation list.
Got to that column, resize as you desire.

hth
"JDH" wrote:

I am having a weird behavior will my workbook! I have 5 columns in my
worksheets that contain a drop box for data validation. My question is, what
controls the width of the drop box? In one of my columns the drop box is
twice the width of the column when I click to open it. No matter how I adjust
the columns width, the drop box opens wider than the columns width. I am
using dynamic range cells for my data validation, and I have adjust the
columns width from that worksheet the match all the other worksheets. No sure
what to try next!

Any help would be appreciated!

JDH