| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pick From List
I right click on cell, find "Pick from List" option, but cannot seem to use it
|
|
#2
|
|||
|
|||
|
The list should show entries from other cells in the adjacent range, in
the same column. Another way to display a list in a cell is to use Data Validation. There are instructions in Excel's Help, and he http://www.contextures.com/xlDataVal01.html Barry wrote: I right click on cell, find "Pick from List" option, but cannot seem to use it -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| Drop dow list complication | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Linear Mode
