Specifying the Width and Alignment of the Combo Box Drop-Down List
Overview
By default, the width of the combo box drop-down list is the current width of the cell as shown in the following figure.
You can
- Set the width to display the longest line of text in the drop-down list. The drop-down list box will be left aligned or right-aligned to the selection box depending on the cell width and the length of the longest line of text in the drop-down list. If the cell width is less than the longest line of text, the drop-down list is left-justified. If the cell width is greater than the longest of text, the drop-down list is right-justified.
- Set the width to display the longest line of text in the drop-down list and right align the drop-down list box to the selection box
- Specify the width as a negative number. The drop-down list box will be right aligned to the selection box.
- Specify the width as a positive number. The drop-down list box will be left aligned or right-aligned to the selection box depending on the cell width and the length of the longest line of text in the drop-down list. If the cell width is less than the longest line of text, the drop-down list is left-justified. If the cell width is greater than the longest of text, the drop-down list is right-justified.