Width of drop down box

[chrisl]

I have a spreadsheet where I am using drop-down boxes to validate input in a couple of columns. In both cases I am using named ranges as the list which details possible entries.

For one of the columns - the width of the drop down options when you click in a cell is the same width as the column width of that column.

For another column, when you click on a cell, the drop down box is much wider than the width of the column. (I have not used any visual basic in this spreadsheet).

I am wondering why this is and how I can control the width of the drop down box because I have some long entries where it would help to have the width of the drop down box to be greater than the width of the column.

 

[Dan Waterloo]

Hi Chris,

Here's a tip on data validation that I haven't used myself yet: http://www.contextures.com/xlDataVal08.html - check out the section called, "Make the Dropdown List Temporarily Wider".