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
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.
Is it possible to create a dropdown list that can have multiple selections?
Did you find out how to change the font size in the validate list? I would like to know too. Thanks
HOW CAN I CHANGE THE FONT OF DROP DWON VALIDATE LIST
Hi Vikram, I don't think you can directly (happy for someone to prove me wrong on that though!) .However, you could create a new range, or defined name, that only contains the unique entries from the 'master' range once each and use that in the data validation reference. Hope that helps. Alan
When using the list option in Data Validation, how does one get it to show only unique values from the reference range?
I can get the pick list from the right click, however I am unable to get the alt down arrow function to work.
The list can only be in a format of TEXT
When I fill a Range in a column and go to the empty cell below the entires and Right Click and GoTo Pick From List, I receive a Blank Drop Down Cell. I have been trying to use this Fuction for some time with no luck yet.