"Fred Smith" wrote:

I would agree that Excel should be able to complete the word for you. From
what you've said, there's no reason Excel shouldn't autocomplete.

One trick you can try is to use Alt+down arrow. This will display the items
in the autocomplete list for that column. Maybe this will help you determine
the problem.

Sorry I couldn't be of more help.

Regards,
Fred.

"jm" wrote in message
...


"Fred Smith" wrote:

What's the word?
Are there any blank cells between the complete word and the cell you are
typing in?
Are there any similar words that start with the same letters (therefore
making it difficult for Excel to decide which one)?
Is there a lot of recalculation involved after you enter data in a cell?

Regards,
Fred.

"jm" wrote in message
...
hi all,i have a problem with excel2003 and all help would be much
appreciated.anyways,i enter quite a bit of data in excel and certain
words
in
some columns are repeated,meaning they are exactly the same.when a word
is
typed in a column and has been previously entered,excel will remember
it.
eg:/ I start typing the word SYD excel will auto-complete the word
'SYDNEY'.excel remembers pretty much all of them except for just this
one
word.it gets typed over and over but excel does not remember it and
does
not
auto-compplete the word,which means i have to type the complete
word.not
saying that i'm a slacker or lazy,just that i noticed this error(if i
can
call it?) and wanted to resolve it.hope this makes sense :)

thanks for your reply Fred :)
the word is MELBOURNE.no blank cells,no spaces.and no,no other similar
words
that start with the same letters.there's no calculation involved,just the
word itself.so therefore methinks excel should pickup the word straight
away
and auto-complete it? if that makes sense?
ps:also,i have not made any changes/modifications to the cell,row or
column
itself.


right..i see,now we're gettin somewhere.. thanks Fred :)
now,if i may ask u another question..how do i,or is there a way to remove
some of the words in the drop down list(when ALT+DOWN arrow) is performed?
cos' there are a few words in the drop down list that "look" similar to
"MELBOURNE".so..i'm thinkin,if i delete the similar words to MELBOURNE,that
might prompt excel to auto-complete? :|
ps:btw,i've had no lessons/training on excel whatsoever since i started
using it a few years ago.just installed/opened excel and learned as i go
along..pretty much self taught..lol