drop down box in cell; autofill
 

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

drop down box in cell; autofill
 

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

drop down box in cell; autofill
 

Thank you,

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

Chris

"Debra Dalgleish" wrote in message
...
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

drop down box in cell; autofill
 

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

C. Bailey wrote:
Thank you,

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

Chris

"Debra Dalgleish" wrote in message
...

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






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