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.
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.