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? |
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. |
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? |
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com