drop down box in cell; autofill

  • Thread starter Thread starter C. Bailey
  • Start date Start date
C

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
 
Thank you,

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

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