How do I store frequently used text in Excel for auto-complete?

[KeithyBX]

Hi,
How do I store frequently used text in Excel for auto-complete?

 

[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

 

[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...

 

[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!

 

[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.