| Home |
| Search |
| Today's Posts |
|
#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: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
| Auto Update A Validation List | Excel Worksheet Functions | |||
| Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
| custom list | Excel Discussion (Misc queries) | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
Linear Mode
