See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"louise" wrote in message
...
i am making a spread sheet and i need to put lots of information on a drop
down list, but not on the spreadsheet,

e.g
Name then a number then a drop down list with all information eg
address
of each family member.