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 :)

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 :)

"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.

Melbourne autocompletes for me. I have xl2003.
--
John C


"jm" wrote:



"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.

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.

"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

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 (ToolsOptions...) 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" wrote in message
...


"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

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 :)

"Fred Smith" wrote:

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 (ToolsOptions...) 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" wrote in message
...


"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