Using autocomplete

N

njamy

I'm using excel to log in customer payments. How can I get autocomplete to
complete customer names so I won't have to type them over and over? Is there
a place I can create a data base of the name? Thanks
 
A

Anne Troy

The only way Excel Autocomplete works is if the value has previously been
entered into the same column, and there are no blank cells between the
values (database) and values that you enter now. So you'd have to do a dirty
little workaround...
*******************
~Anne Troy

www.OfficeArticles.com
 
Top