To create a dropdown list in a cell, you can choose DataValidation.
There's information in Excel's help file, and some instructions he
http://www.contextures.com/xlDataVal01.html

This MSKB article has information on AutoComplete in Excel 97:
http://support.microsoft.com/default.aspx?id=177423

and for Excel 2000:
http://support.microsoft.com/default.aspx?id=212069


C. Bailey wrote:
I have seen spreadsheets that have drop down boxes that appear to be part of
a cell i.e. they don't appear to be cut and paste there. Does Excel have
this functionality, and if so, how do I use it?

I have also noticed that if you are typing an entry that you recently typed,
Excel will automatically complete the word you are typing. However, there
appears to be a limited "memory" because it does not remember entries I made
a while back. Is there a limit, and is there a way to expand how far back
it remembers?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html