Pick from list

[John]

Excell has a great feature that enters data repeatedly in
a column, when it has been entered once. You can also
right click and select the "pick from list" feature.
What I would like to do is create a data base that works
the same way.Is there a way to do that?
My main goal is to hide my list from veiw and not be
printed with the data sheet.

 

[icestationzbra]

perhaps you want something like a data validation list.

check the following link to see if it fits your requirement.

http://www.contextures.com/xlDataVal01.htm