Repeats

[annonymous]

On one of my worksheets I type the day of the week in the first column,
followed by the date in the second column etc.
Since the current entry is in line 3,675th when I typed the first letter of
the day the rest was completed automatically. E.g. If I typed M then onday
followed, as were entries of the same gist in other columns, when the first
word of the information was typed.
Suddenly this stopped. Why I have no idea, but would appreciate if someone
told me how to restore this time and typing savings. Thanks!

 

[Bob Phillips]

Tools>Options>Edit, check that Enable Autocomplete for Cell Values is
checked

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[annonymous]

Thank you for the reply. The Enable Autocomplete for Cell Values is and was
checked, but I still suffer from the same defficiency. What else can you
suggest? Thanks.

 

[George]

Firstly,
Check if you have a typo in your list.
Because the auto complete only kicks in when it finds a unique spelling
eg. Monday and Mondday
It wont kick in till after the letter a

Secondly,
The auto complete only works if there is data directly above it.
So I'm just wondering if you have a blank cell between what you are
typing and all the other lines.
I'm guessing you don't, so in that case can you press ALT - DOWN ARROW
Does the list show up?
If it does then the auto complete should be working.
Which means that you may have just discovered a new bug

Thirdly,
Try copying just 1 column to a NEW blank workbook
and goto the last line and see if it will autocomplete.
If that works, then the original file just may be damaged.

Good luck
George

 

[Pete_UK]

I've found this happening in very long lists - I assumed that Excel
only looks back a certain number of rows and if you don't have Monday
in that group of rows then it can't complete the word for you. If my
assumption is correct, I suppose with some experimentation you could
discover how long the block is - I would guess that it would be a
maximum or 1000, as this is what Excel uses in a filter pull-down.

Hope this helps.

Pete