Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing in Cells - Cell Remembers From First Few Letters
How do you make the cells remember - Like I start to type 'Phoenix' and the
word just pops in like it remembered the word. Is this random or does it have to see a pattern? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing in Cells - Cell Remembers From First Few Letters
"jeanngoodyear" wrote:
How do you make the cells remember - Like I start to type 'Phoenix' and the word just pops in like it remembered the word. Is this random or does it have to see a pattern? In Excel 2003, this is controlled by the AutoComplete option under Tools Options Edit. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing in Cells - Cell Remembers From First Few Letters
Not random.
Controlled by autocomplete being enabled in Editing options. And the values Excel looks at for autocomplete must be contiguous in the same column as your entry cell. Gord Dibben MS Excel MVP On Sun, 22 Nov 2009 15:40:01 -0800, jeanngoodyear wrote: How do you make the cells remember - Like I start to type 'Phoenix' and the word just pops in like it remembered the word. Is this random or does it have to see a pattern? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Link remembers absolute path?? | Excel Worksheet Functions | |||
how to show a list of words by typing a few letters | Excel Discussion (Misc queries) | |||
Navigate to an item in pulldown by typing first couple of letters | Excel Discussion (Misc queries) | |||
pre-fill cell by typing first few letters of a list | Excel Worksheet Functions | |||
Speed Search in pick list by typing only first few letters | Excel Discussion (Misc queries) |