Enter a value in a cell with a drop-down list

To enter a value in a cell with a drop-down list, follow these steps:

1.Select the cell. A prompt for entering a value will be displayed above the cell, if it was created.

2.Do one of the following:

•Expand the drop-down list and select the desired value. To work with the drop-down list, you can use the mouse or keyboard keys (see the table).

•Enter the value manually. The entered value must match character by character with the required value in the drop-down list. The case of characters is not taken into account when entering a value. Press Enter or click the  button in the Formula bar, or click any other cell in the sheet/header of any column/row.

If the value entered manually is incorrect, the drop-down list is automatically expanded. An error message is displayed at the top of the list.

To edit the entered value, do one of the following:

•Select the correct value from the drop-down list.

•Start entering the correct value manually. The drop-down list will automatically close.

•Close the drop-down list by clicking the  button at the top of it or by pressing Esc. Enter the correct value manually.

The table lists the keyboard shortcuts that are used when working with the drop-down list.

The commands One screen down and One screen up are used to quickly view long drop-down lists. When executing commands, the list scrolls to the next or previous items.