Chapter 1: Drop-down lists (Data Validation)
Exercise 3: Choose from a drop-down with the keyboard
Task
Set C2 to "Done", C3 to "On hold" and C4 to "Done". Open the drop-down with Alt + ↓.
Moves 0 (target 3)3 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Project | Rep | Status | |
| 2 | Acme quote | Smith | ||
| 3 | Birch invoice | Johnson | ||
| 4 | Cobalt contract | Williams | ||
| 5 | Delta order | Brown | ||
| 6 | ||||
| 7 |
Set C2 to "Done", C3 to "On hold" and C4 to "Done". Open the drop-down with Alt + ↓.
This drill is for computer screens. On a phone you can review the steps.
- Select C2 and press Alt + ↓ to open the list (on a Mac, Option + ↓)
- Press ↓ to reach "Done" and press Enter
- Do the same for C3 and C4
Key takeaway
You can choose with the arrow keys and Enter, without reaching for the mouse.
See How to create a drop-down list in Excel for details.