If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can you enable auto complete from a custom list in Excel?
|
#2
|
|||
|
|||
No.
Autocomplete or "Pick from list" gets its information from cells above and below the point in the same column that you are entering new data. A custom list entered in ToolsOptionsCustom Lists is used for autofilling and when sorting. Gord Dibben Excel MVP On Thu, 17 Mar 2005 13:27:01 -0800, "poaq" wrote: |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto Complete Problem / Observation | DavidJ726 | General Discussion | 9 | March 5th, 2005 12:27 AM |
E-mail Display name is wrong | Jane Nangle | Contacts | 9 | February 4th, 2005 10:05 AM |
not in list Auto Msg | Chris | New Users | 1 | November 10th, 2004 04:03 PM |
Auto update contacts in Distribution List? | Jerry Crosby | Contacts | 1 | November 1st, 2004 08:47 PM |