Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Typing in Cells - Cell Remembers From First Few Letters
0 views
Skip to first unread message
jeanngoodyear
Nov 22, 2009, 6:40:01 PM11/22/09
to
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?
word just pops in like it remembered the word. Is this random or does it
have to see a pattern?
Joe User
Nov 22, 2009, 6:46:47 PM11/22/09
to
In Excel 2003, this is controlled by the AutoComplete option under Tools >
Options > Edit.
Gord Dibben
Nov 23, 2009, 11:08:11 AM11/23/09
to
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
0 new messages