I need help getting Excel to auto-fill cells when I begin typing .
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 |
Hi Todd
Tools/Options/Edit and check the Enable the Auto complete for cell values check box. HTH Michael "todd" wrote: 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 |
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...) "Michael" wrote: Hi Todd Tools/Options/Edit and check the Enable the Auto complete for cell values check box. HTH Michael "todd" wrote: 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 |
All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com