Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autocomplete
I am entering in a list of around 10,000 company names into an xcel worksheet
the auto-complete function sometimes works when I retype the exact same company namein the same column, but will then stop working for no reason.Any suggestions on how to solve this problem. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autocomplete
I found this myself some time ago. I came to the conclusion that Excel
only looks back a certain number of rows (1000?) to see if there is a match, though I don't know if this is true. Of course, it might be that you have very similar names, eg Roberts and Robertson, and Excel can only distinguish between these when you type the second "o" - adding the final "n" for you is not much help.<g Hope this helps. Pete Ebony wrote: I am entering in a list of around 10,000 company names into an xcel worksheet the auto-complete function sometimes works when I retype the exact same company namein the same column, but will then stop working for no reason.Any suggestions on how to solve this problem. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autocomplete
Another possibility (which I learned from this board in the not too future
past.) Excel likes contiguous ranges so it seems that if there are gaps in your data (apparently in either the column you are in or the one to the immediate left) auto-complete will not pick up data from before the gap. Since I read about this, I have noticed it appears to be true. I don't know about the certain # of rows as that has not come up for me. -- Kevin Vaughn "Pete_UK" wrote: I found this myself some time ago. I came to the conclusion that Excel only looks back a certain number of rows (1000?) to see if there is a match, though I don't know if this is true. Of course, it might be that you have very similar names, eg Roberts and Robertson, and Excel can only distinguish between these when you type the second "o" - adding the final "n" for you is not much help.<g Hope this helps. Pete Ebony wrote: I am entering in a list of around 10,000 company names into an xcel worksheet the auto-complete function sometimes works when I retype the exact same company namein the same column, but will then stop working for no reason.Any suggestions on how to solve this problem. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autocomplete
I'm guessing I meant distant past rather than future past.
-- Kevin Vaughn "Kevin Vaughn" wrote: Another possibility (which I learned from this board in the not too future past.) Excel likes contiguous ranges so it seems that if there are gaps in your data (apparently in either the column you are in or the one to the immediate left) auto-complete will not pick up data from before the gap. Since I read about this, I have noticed it appears to be true. I don't know about the certain # of rows as that has not come up for me. -- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
autocomplete
I thought that was the case <bg
Pete Kevin Vaughn wrote: I'm guessing I meant distant past rather than future past. -- Kevin Vaughn "Kevin Vaughn" wrote: Another possibility (which I learned from this board in the not too future past.) Excel likes contiguous ranges so it seems that if there are gaps in your data (apparently in either the column you are in or the one to the immediate left) auto-complete will not pick up data from before the gap. Since I read about this, I have noticed it appears to be true. I don't know about the certain # of rows as that has not come up for me. -- |
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) |