Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using autocomplete
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 |
#2
|
|||
|
|||
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 "njamy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autocomplete? | Excel Discussion (Misc queries) | |||
Autocomplete numbers help pls! | Excel Discussion (Misc queries) | |||
Autocomplete function | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) |