Auto complete

[Gene L.]

My e-mail program inserts a name when just a few initial letters are
entered. Can Excel do this when updating a list of customers (or others)? It
would be much easier than retyping the entire name each time.
Many thanks.
Gene L.

 

[Gord Dibben]

If the list of customer names is already entered in a column above or below
your point of entry, autocomplete will work.

Must have it enabled in Tools>Options>Edit and point of entry must be part
of the contiguous range above or below.

2007............Orb>Excel Options>Advanced>Editing Options


Gord Dibben MS Excel MVP

 

[Gene L.]

Dear Gord:
Works like charm - Many thanks
Gene L

If the list of customer names is already entered in a column above or
below
your point of entry, autocomplete will work.

Must have it enabled in Tools>Options>Edit and point of entry must be part
of the contiguous range above or below.

2007............Orb>Excel Options>Advanced>Editing Options


Gord Dibben MS Excel MVP