For some reason - I can not type the same word and have it automatically come
up the next time when I enter it will not automatically come up. I must of
lost that option some how. Please help

I guess you need to select Options from the Tools menu. Then select the Edit
tab and check the 'Enable Auto Complete for cell values' box

Hope I have interpreted your problem correctly

Regards
Philip

"K@Betts" wrote in message
...
For some reason - I can not type the same word and have it automatically
come
up the next time when I enter it will not automatically come up. I must
of
lost that option some how. Please help

Make note that "auto complete works only when the data is contiguous in one
column".


Gord Dibben MS Excel MVP

On Mon, 23 Jan 2006 17:03:12 -0000, "Philip Reece-Heal"
wrote:

I guess you need to select Options from the Tools menu. Then select the Edit
tab and check the 'Enable Auto Complete for cell values' box

Hope I have interpreted your problem correctly

Regards
Philip

"K@Betts" wrote in message
...
For some reason - I can not type the same word and have it automatically
come
up the next time when I enter it will not automatically come up. I must
of
lost that option some how. Please help