How make excel remember words you commonly use from one document to next?

[chadinark]

I've looked for the answer to this but not really seeing it. Seems like every related topic I see discusses how to use autocomplete with one document. I get that. And I use it but that only works once you've already typed that word once in the document, right? Can I have Excel remember words or phrases I commonly use from one document to the next? Seems like Word will do this. Or maybe can you set up a drop-down as a template that will store those words for you, which you can add/delete from as you like? if that makes any sense...

I use 07 version.

Thanks!
chad

[mlopardo]

Attach an example if possible.

[protonLeah]

Autocorrect is the feature to use. For example, in the Replace box type *s, then in the WITH box type September ( with a space before and after) , click add, and from then on, in all documents, whenever you type *s, Excel will replace it with September (including the spaces). That works for phrases as well, but I don't know how long a phrase can be.