Display AutoComplete List in Excel
The Display AutoComplete List shortcut shows all previously entered values in a column that match the current input, making data entry faster and more accurate.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + Down Arrow | Option + Down Arrow |
What Does This Shortcut Do?
Pressing this shortcut displays a dropdown list of previously entered values in the current column that start with the letters you typed. You can quickly select an entry without typing the full value.
How to Use the Shortcut
- Click on the cell where you want to enter data
- Press Alt + Down Arrow (Windows) or Option + Down Arrow (Mac)
- Use the arrow keys to select the value from the AutoComplete list
- Press Enter to insert it into the cell
Tips & Best Practices
- Make sure the column contains previous entries; AutoComplete only works with existing data
- Combine with data validation for consistent entries
- Useful for repetitive data entry tasks, such as product codes or names
FAQ
- Q: Can I use AutoComplete with filtered lists?
- No, AutoComplete only considers visible cells in the same column.
- Q: Can I turn off AutoComplete?
- Yes, go to File → Options → Advanced → Editing options → uncheck "Enable AutoComplete for cell values".