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:
- Select the cell. A prompt for entering a value will be displayed above the cell, if it was created.
- 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 below ).
- 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
Enteror click the
button in the Formula bar, click any other cell in the sheet, any column header, or any row header.
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.
tip
If the Show value list setting is disabled, the error message is displayed without a drop-down list.
The table below lists the keyboard shortcuts that are used when working with the drop-down list.
| Keyboard shortcut | Description |
|---|---|
Alt+↓ | Open the list |
↓ and ↑ | Select a value |
Enter | Apply value |
Home | Select the first value of the list |
End | Select the last value of the list |
Page Down | One screen down |
Page Up | One screen up |
Esc | Close the 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.