Tip Printed from ExcelTip.com

---

Quickly Entering Text into Cells from a List of Previous Entries or a Validation List


To select from a list of previous text entries or from a Validation list:

• Select the empty cell under the last filled cell.
• Press Shift+F10 or right-click and then select Pick from Drop-down List from the shortcut menu.
OR
Press Alt+ Down Arrow.