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

CATEGORY - Excel Keyboard Shortcuts VERSION - All Microsoft Excel Versions

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.
Screenshot // Quickly Entering Text into Cells from a List of Previous Entries or a Validation List