K
KeithyBX
Hi,
How do I store frequently used text in Excel for auto-complete?
How do I store frequently used text in Excel for auto-complete?
D
Dave Peterson
Autocomplete uses the cells directly above the cell.
Here are a couple of links:
XL97: AutoComplete Fails After 102 Rows Past Last Occurrence
http://support.microsoft.com/default.aspx?id=177423
XL2000: AutoComplete Works Differently After 102 Rows Past Last Occurrence
http://support.microsoft.com/default.aspx?id=212069
Here are a couple of links:
XL97: AutoComplete Fails After 102 Rows Past Last Occurrence
http://support.microsoft.com/default.aspx?id=177423
XL2000: AutoComplete Works Differently After 102 Rows Past Last Occurrence
http://support.microsoft.com/default.aspx?id=212069
S
StumpedAgain
Care to be a little more specific?
You can type it in a cell and then copy/paste it to your desired location,
but I don't think that's what you're after...
You can type it in a cell and then copy/paste it to your desired location,
but I don't think that's what you're after...
S
StumpedAgain
Ooops... just re-read your post and it clicked... my bad 
I'm not sure you can add words to the auto-complete. I only know how to add
them to the auto-correct. Good luck!
I'm not sure you can add words to the auto-complete. I only know how to add
them to the auto-correct. Good luck!
G
Gary''s Student
Hi SA:
You can use AutoCorrect instead..For example, enter qu should be replaced by
question and its just as good autocomplete.
You can use AutoCorrect instead..For example, enter qu should be replaced by
question and its just as good autocomplete.