Auto Complete (???) in Excel

[Alison]

Hi,

I use Excel Workbooks with multiple sheets. I am trying to find out how to
have the various cells complete the text I type in. I know it has to be text
I have previously used in the same workbook. It seems to be a hit or miss
sort of situtation, sometimes it works and other times it does not. What
"magic" do I need to work to have it auto fill all the time?

Thanks for any help at all.......
Alison

 

[Luke M]

If you have used the word before in the same column, and there are no gaps
(blank cells) between the last instance of the word, and the cell you are
working on, Excel will be able to suggest an ending.

It also waits until it can pick definitively what word you are typing.

Example:
Cars
Carpet
Dog
(you would have to type "carp" before Excel suggests "carpet")