Correction..

Alt+DownArrow to choose from list. This will ignore the blank entries too.

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

After typing in the first few characters if you dont get a unique matched
entry hit Alt+Enter to choose from the dropdown list..

--
Jacob (MVP - Excel)


"TQ" wrote:

Thanks Jacob, I belive my case is more than one entry starting with the
similar begining . Anyway, any solutions to solve this kind of problem ? It
is impossible for me to change the similar name of customer. Is tat possible
excel will list out few similar in a list to let me choose ? Thanks.


"Jacob Skaria" wrote:

--The cells must contain either text or a combination of text and numbers.
Cells that contain numerics, dates, or times are not considered.

--Excel displays the matched entry when you hit the first alpha character.
Suppose you have an entry as " -apple" ; excel displays the matched entry
only when you enter " -a"..Again if there are more than one entry starting
with " -a" excel will not display the matched entry unless you type in the
other characters so that it filter down to match one entry..

--Also if you have entries such as below excel will not be able to find ** a
** matched entry and hence not displayed...Hope this helps...

-a
-ap
-app
-appl
-apple
-apples


--
Jacob (MVP - Excel)


"TQ" wrote:

Thanks Jacob, actually my data don have any blank field between the cell. I
jz don understand why when I key in the repeated data, some will autocomplete
and some not, I suspect it because start with " -" , I don't know whether my
assumption correct.

"Jacob Skaria" wrote:

The match that Excel fetches is nothing but the contents of the immediately
adjacent cells above the one in which you are entering the data. It stops
trying to match entries when a blank cell is reached. Incase you have
information from A1 to A5 and then from A7 to A10; if you make a new entry in
A11, excel only try to match entries in A7:A10.

If you have blank cells between the range try the below workaround. I am not
sure whether this would help (depends on how your data is managed.).

--Select the column. Press F5Special select Blanks Hit OK. This would
select all the blank cells in the column.

--The active cell would be the first blank cell in the column. Active cell
will have a white background even when selected.

--Press apostrophe (') key. Dont press Enter key instead press Ctrl+Enter.

--Now try autocomplete in a new cell. As Dave mentioned when you enter new
data make sure you dont leave blank cells.


--
Jacob (MVP - Excel)


"TQ" wrote:

Hi, I would like to key in data which duplicate before, I notice that some
will be auto complete but some not, I already check the autocomplete function
in Tools.

Anyone who know the reson and can provide solutions ? All my data start wz "
- " i.e - Willam or - Robert & etc.

Thanks.