I need help getting Excel to auto-fill cells when I begin typing .

[Guest]

I use Excel to create quotes for my customers daily, it seems that I spend
more time typing than I should...It would be nice to know how to enter a list
into excel so that when I begin typing a product name that it would reconize
the first few letters and auto fill for me so I could tab to the next column.
I've know about using the fill handle and setting up repeating lists there,
but haven't had any luck with generating "memory" or a history of used terms
for excel to key off of other than keeping all quotes on the same worksheet.

would really appreciate some input if anyone has ideas
thank you todd

 

[Guest]

Hi Todd
Tools/Options/Edit
and check the Enable the Auto complete for cell values check box.

HTH
Michael

 

[Guest]

You can add to your dictionary. Go to tools, spelling, add...
Say you were going to type in Mississippi or some other long word...choose a
couple of letters you will remember, follow directions to add to your
dictionary, then all you have to do is type your code (I'd put in ms for
Microsoft, my initials for my name...)