Tip Printed from ExcelTip.com

---

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


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

1. Select a cell in a list or a blank cell under the last filled cell.
2. Press .