software

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

quot;K@Bettsquot; gt; wrote in message
...
gt; For some reason - I can not type the same word and have it automatically
gt; come
gt; up the next time when I enter it will not automatically come up. I must
gt; of
gt; lost that option some how. Please help
Make note that quot;auto complete works only when the data is contiguous in one
columnquot;.Gord Dibben MS Excel MVP

On Mon, 23 Jan 2006 17:03:12 -0000, quot;Philip Reece-Healquot;
gt; wrote:

gt;I guess you need to select Options from the Tools menu. Then select the Edit
gt;tab and check the 'Enable Auto Complete for cell values' box
gt;
gt;Hope I have interpreted your problem correctly
gt;
gt;Regards
gt;Philip
gt;
gt;quot;K@Bettsquot; gt; wrote in message
...
gt;gt; For some reason - I can not type the same word and have it automatically
gt;gt; come
gt;gt; up the next time when I enter it will not automatically come up. I must
gt;gt; of
gt;gt; lost that option some how. Please help
gt;