List Length. The drop down list shows a maximum of 8 items at a time.
- How do I change the size of a drop-down list in Excel?
- Why is my drop-down list so wide?
- How do I make a drop-down list show more than 8?
How do I change the size of a drop-down list in Excel?
The simple solution is to widen the column that the drop-down box is in. You can adjust the column manually by dragging the border of the column header.
Why is my drop-down list so wide?
In most cases: the worksheet had other cells with data validation in the same row. all dropdowns became the width of the widest dropdown. one of the data validation lists is in a merged cell.
How do I make a drop-down list show more than 8?
By default, a data validation drop-down list only shows 8 items in the list when clicking the drop-down arrow. So you need to drag the scroll bar down for viewing more values in the list.