excel does not remember certain words

[jm]

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

 

[Fred Smith]

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]

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.



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.

 

[John C]

Melbourne autocompletes for me. I have xl2003.

 

[Fred Smith]

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]

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.



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

 

[Fred Smith]

The only way I know of to edit the entries in the autocomplete list is to
not enter them in the first place. The list is composed only of other
entries in that column. If you have vaious spellings of Melbourne in the
column, correct them and the autocomplete list should update.

You could try turning off autocomplete (Tools>Options...) and turning it
back on to see if that has any effect, but I doubt it.

Please top post any replies so the conversation can be followed easily.
Fred.

 

[jm]

alrighty then,corrected 1 of the Melbourne spellings and voila! Melbourne now
auto-completes..hehe..simple as that
hey,thanks a million for your time and help Fred.
cheers