Display the AutoComplete list
Master this Excel shortcut with our comprehensive guide
Data Entry Shortcuts in Excel
Alt + ↓
⌥ + ↓
How to Use This Shortcut
Keyboard Shortcut
Alt + ↓
Instructions
1. Place cursor in a cell with repeated entries above
2. Press Alt + Down Arrow
3. Displays the AutoComplete list to pick from
2. Press Alt + Down Arrow
3. Displays the AutoComplete list to pick from
Keyboard Shortcut
⌥ + ↓
Instructions
1. Go to the cell
2. Press Option + Down Arrow
3. Shows AutoComplete list
2. Press Option + Down Arrow
3. Shows AutoComplete list
💡 Pro Tip: Saves typing time when working with repeated values like months or categories.
Quick Actions
More Data Entry Shortcuts in Excel
Ctrl + Enter
Shift + Enter