You could make a separate list of just the cells you want. You could then
hide that list or place it off the page so it isn't seen.

As for making the list autofill, I don't think you can do that in a Drop
Down List.




"eternal_cat via OfficeKB.com" wrote:

K, I wanted it to contain only one instance of each suburb, whereas the list
is containing all the instances of the suburbs in the range that i have
selected. I also want to have this list so that it will autofill the suburbs
as i type them (since there is only one instance of each suburb). Like in
Excel help in the index when you type in a word and it automatically scrolls
down to a matching word.

thanks.


Easy.

Select the cell where you want to place the Drop Down.
From the Menu bar, select Data, then Validation.
On the Settings tab of the popup select List from the Drop Down.
Then click on the red arrow icon on the right side of the Source Box.
Now select the range of cells that contains your list.
Press Enter and click OK.

Hi, i was wanting to know how to make a drop down list for column F where the
contents of this list would be all the suburbs i had entered into that column
[quoted text clipped - 3 lines]

cat.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200511/1