| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Complete
I have excell 2000 and have 300 names in one column and would like for excell
to auto complete on another column but it wont. When I went to HELP, all I canfigure out is it says its out of my data region but I don't know how to change that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Complete
hi
auto complete looks at data in the same column above the activecell so autocomple will not work in another column. sorry regards FSt1 "elihue" wrote: I have excell 2000 and have 300 names in one column and would like for excell to auto complete on another column but it wont. When I went to HELP, all I canfigure out is it says its out of my data region but I don't know how to change that. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Complete
FSt1 wrote:
hi auto complete looks at data in the same column above the activecell so autocomple will not work in another column. sorry regards FSt1 "elihue" wrote: I have excell 2000 and have 300 names in one column and would like for excell to auto complete on another column but it wont. When I went to HELP, all I canfigure out is it says its out of my data region but I don't know how to change that. Would a custom list be of any use to you, just a thought. Cheers L |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto complete only for one row down? | Excel Discussion (Misc queries) | |||
| Auto Filter With Auto Complete Ability | Excel Discussion (Misc queries) | |||
| Auto complete | Excel Worksheet Functions | |||
| auto complete | Excel Worksheet Functions | |||
| Auto complete | Excel Discussion (Misc queries) | |||
Linear Mode
