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.
Press Alt+ Down Arrow.
Screenshot // Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.