Please help me i'm an idiot

T

thuma1004

I have some templates that I've been using for a year now. When I used
to type a persons name in a cell, and then go to type the same name in
a cell a couple of rows down in the same column, it would automatically
put the whole name in after I typed just one letter. Now it doesn't do
that for me. What did I do to make this stop for me, and how can I get
it to do it again?
 
D

Don Cossitt

Billy Bob Thornton
Crazy Larry
Jesse James

Now if I do as you say you used to, given this list, it
will finish after the first letter. But if you add
Billy Joe Bob
to the list you will have to type more than one letter
for Excel to have a clue what you want when adding Billy Bob again -
usually by the time you got to 'B' at Bob then Bob Thornton would complete.

HTH
doco
 
Top