|  

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

Rate This Tip
12 34 5
Rating: 2.84     Views: 59544
Data Analyist
Jack J  Posted on: 31-12-1969
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.
pick from list
Henry Zheng  Posted on: 31-12-1969
The list can only be in a format of TEXT
Alt down arrow keys
L.  Posted on: 31-12-1969
I can get the pick list from the right click, however I am unable to get the alt down arrow function to work.
Unique values in validation lists
Vikram  Posted on: 31-12-1969
When using the list option in Data Validation, how does one get it to show only unique values from the reference range?
Reply: Unique values in validation lists - Vikram from Bangalore,India wrote on August 8, 2003 8:35 AM EST
Alan  Posted on: 31-12-1969
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.
VALIDATE LIST
shamyn  Posted on: 31-12-1969
HOW CAN I CHANGE THE FONT OF DROP DWON VALIDATE LIST
Validate list font
Matt  Posted on: 31-12-1969
Did you find out how to change the font size in the validate list? I would like to know too. Thanks
Multiple Select dropdown list
jerome  Posted on: 31-12-1969
Is it possible to create a dropdown list that can have multiple selections?
Name
Comment Title
Comments