"Pick From List . . . "

[JP]

Hello:

When I do a right click on a cell, I get the popup menu that allows the
selection of "Pick From List. . ." I did a search in Help and with the
Microsoft Knowledgebase, but could find no reference to this. How does one
populate the list...where is the list from, etc.?

Thanks.

JP

 

[Guest]

.... found via HELP!


Pick From Drop-down List command

You use the Pick From Drop-down List command to quickly insert a value into
an empty cell. The command saves you having to retype an existing value that
resides in the same column. To try it, follow these steps:

In a blank column of a worksheet, enter a list of items. "Apples,"
"oranges," "peaches," and "pears" will do if you can't think of a list
off-hand.
Right-click the cell directly below the last item, and click Pick From
Drop-down List.
Select an item from the list.

HTH

 

[Guest]

It looks at the populated cells above the cell you are in
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

Excel builds the list internally based on entries above the active cell. I
think it lists the same values that AutoComplete uses.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Gord Dibben]

Or directly above the populated cells.


Gord Dibben MS Excel MVP

 

[JP]

Thanks all..

It was a major clarification for me... Really appreciate the info

JP