Right-click Drop down list

G

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
How to delete a drop down box in Excel 2007 1
Drop Down List Contains the List Header Row 1
Size of drop down in validation list 2
drop-down menu disappeared 6
drop downs showing down arrow 4
Double Drop-Down Validation in Excel 2007 1

Top