Autocomplete doesn't work that way.

Only looks at cells above or below in the one column in which you are entering
data.


Gord Dibben MS Excel MVP

On Sat, 12 Jan 2008 09:14:43 -0800 (PST), stremetzky
wrote:

Hi,
I have Sheet1 with different names in a column.
In the Sheet2 I have to type in the names in certain cells. What can I
do that I don't need to write the whole name again but after I beggin
typing excel would check the list of names in Sheet1 and help me to
autocomplete it.

Thank you for your suggestions,
stremetzky