Setting cells to 'List' validation lets users choose from a dropdown, eliminating typos and inconsistent entries. The Alt+A+V+V sequence opens the dialog in four keystrokes, entirely from the keyboard.
Shortcuts you will master in this article
Alt + A + V + V / Alt + ↓
Variations like 'Resolved', 'Complete', 'Done' — or 'Tokyo' versus 'Tokyo, Japan' — cause filters and aggregations to produce inaccurate results when mixed together. Data validation with list restriction eliminates this by constraining input to a defined set of choices.
The Data Validation feature is buried deep in the menus; using the mouse requires clicking the Data tab, then the Data Validation button, then configuring inside the dialog. Knowing Alt+A+V+V opens it in four keystrokes.
Using dropdown list setup as an example, here's how to complete the entire operation without touching the mouse.
Select the target cell or cell rangeClick the cell or use Shift+Arrow to select a range. To apply to an entire column, click the column header.
Tip: You can also apply validation to cells that already contain data.
Alt → A → V → VPress Alt to activate the ribbon → A to open the Data tab → V to open the validation submenu → V to open the dialog. The 'Data Validation' window appears.
Tip: This shortcut works across Excel versions. It's universally applicable wherever the Data tab is visible.
Tab to 'Allow' and select 'List'Once the dialog opens, Tab to the 'Allow' dropdown, then use the arrow keys to select 'List'. A 'Source' field appears.
Tip: The default selection is 'Any value'. Press the down arrow a few times to reach 'List'.
Enter the list choices in 'Source', separated by commasIn the Source field, type choices separated by commas, e.g., 'Resolved,In Progress,Pending'. Alternatively, reference a cell range on another sheet (e.g., Sheet2!$A$1:$A$5).
Tip: Using a referenced list from another sheet means you can add or change options later by simply editing those cells.
Press Enter to confirmPress Enter to save. With the target cell selected, press Alt+↓ to open the dropdown list you just configured.
Tip: After setup, copy the validation to other cells with Ctrl+D or Ctrl+C → Ctrl+V — the validation rule is included in the paste.
Excel Shortcut Practice
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + Shift + L | Toggle AutoFilter |
Ctrl + F | Find |
Ctrl + 1 | Format Cells Dialog |
A. If the sheet is protected or cells are merged, the dialog may not open. Check Review → Unprotect Sheet.
A. Select the validated cell, press Alt+A+V+V to reopen the dialog, and edit the Source field. If you're referencing a list on another sheet, just add entries to that list directly.
A. By default, Excel shows an error alert but still allows entry. On the 'Error Alert' tab, change the Style to 'Stop' to completely block values outside the list.
A. Press Alt+A+V+V to open the dialog, then click 'Clear All' to remove the validation.
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →