Editing a Combo Box
• By default, a combo box has a single name and value columns.
• On the Input/Output tab, in the Controls group, use the Edit icon. Alternatively, right-click the combo box and select Edit from the shortcut menu.
• To add or remove rows and columns, use the respective ribbon icons or keyboard shortcuts that you use in tables and matrices. Similarly, the Delete key deletes the selected cells, column, and rows.
 |
Combo boxes display a maximum of 9 items. To view additional items, use the vertical scroll bar.
|
• To move between cells in edit mode, use the tab and arrow keys.
• Cells in the combo box must have only one text line.
• You can use only base units in a combo box. For derived units, create a custom unit in your worksheet and use it in the combo box.
Hide or Collapse the Left Side
Hiding the left side of a combo box disables its display. Collapsing the left side disables its display and aligns the combo box to the left.
• To toggle the display of left side of an expression, on the Input/Output tab, in the Controls group, click Hide Left Side. To view the hidden left side, click the expression.
• To collapse the display of left side of an expression, on the Input/Output tab, in the Controls group, click Collapse Left Side. To view the collapsed left side, click the expression.
|
|
The Hide Left Side toggles only when right-hand side of the expression has a single combo box.
|