Excel problem

Tweet

I'd like a bit of entry information for both Excel and Access. When I am typing in a field the first time, I type the whole word. When I type the same word subsequently, I would like for the word to complete itself after the first few keystrokes. Example: First type I type Leather. Second time, I type Lea (and then the word pops up and I can simply hit enter and it will complete itself.) I know this is possible in both Excel and Access, I just cannot remember the commands to make the applications do it! Hope I am being clear, and thanks for any help you can give.