Auto complete

  • Thread starter Thread starter Gene L.
  • Start date Start date
G

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.
 
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
 
Dear Gord:
Works like charm - Many thanks
Gene L
Gord Dibben said:
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
Click to expand...
 
Back
Top