AutoComplete will search only upto the first blank cell (in both directions)
in the Column...

You may enter something like zzzDeleteThisLater in the blank cells, complete
your entry and then remove them (search and replace with nothing) once you
are done.

To enter in all blank cells at once...
select the range, press F5, choose Special then Blanks
Type what you want and press CTRL-ENTER


"anirban" wrote:

my autotext completion is not seaching the entire document before giving m a
probable option from the earlier entered text in the coloumn it is only
searching a part of the column and giving suggested values on basis of
that......can anyone please help