View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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?