How do i set up a drop down list and hide my list data.

B

Bill

hi, i've set up a drop down list using the validation tool and its working
fine, but my entities that i want to drop down in the list have to appear on
my sheet in order for them to appear in the drop down list i.e. if i delete
the entites on the sheet they are also deleted from my list. Can i store the
entites within the fileso the don't appear on the spread sheet.

Any help would be greatly appreciated,

Kind Regards,

Bill
 
R

Roger Govier

Hi Bill

The list can be on another part of the sheet, out of site and in an area
where you are not deleting.
Alternatively, they can be on another sheet if you give the list a name.
On sheet2 in cells A1:A10 enter the items you want to appear on the list
Insert>Name>Define> Name Mylist Refers to Sheet2!$A$1;$A$10

On your Data Validation cells, use List and in the Source enter =Mylist

If it is only a short list, then you could type them straight into the
Data Validation source box, with commas between each item. Do not type
an = sign before the list in this case.
Apples,Pears<Oranges,Lemons,Plums

Debra Dalgleish has some great information on using lists in Data
Validation on her site at
http://www.contextures.com/xlDataVal01.html
 
Top