drop down box in cell; autofill

[C. Bailey]

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?

Chris

 

[Debra Dalgleish]

To create a dropdown list in a cell, you can choose Data>Validation.
There's information in Excel's help file, and some instructions here:
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]

Thank you,

Is there a work around for the autocomplete non-functionality, or do I just
have to live with it?

Chris

 

[Debra Dalgleish]

You can use the Pick from List feature, as described in the MSKB
article, or create some AutoCorrect entries for recurring items.