Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right-click Drop down list
I created a drop down list using Validation. However I noticed that when
right-clicking on a cell there's a choice for "pick from drop down list". When I do that on my cell containing the drop down list it's empty. Apparently this right-click list is filled a different way, other than validation. Can someone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right-click Drop down list
The Pick From List you are describing is more like autocomplete. What it is
doing is it is looking at the values you have in the cells above and below to create a list of potential values. -- HTH... Jim Thomlinson "Joe M." wrote: I created a drop down list using Validation. However I noticed that when right-clicking on a cell there's a choice for "pick from drop down list". When I do that on my cell containing the drop down list it's empty. Apparently this right-click list is filled a different way, other than validation. Can someone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tool drop down and right click choices are missing | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do you activate the right click drop down menu in Excel? | Setting up and Configuration of Excel | |||
I can't get a drop down list when a do a right click on a cell | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |