» Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
• 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.
Book Store:
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 TEXTAlt 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 LISTValidate 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. ThanksMultiple Select dropdown list
jerome Posted on: 31-12-1969
Is it possible to create a dropdown list that can have multiple selections?Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
