If you actually mean "Autocomplete" and not "Autofill" then be aware that the
data must be contiguous in the same column above or below the cell you expect
the autocomplete to work.


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 16:24:00 -0800, DSV wrote:

Autofill in a basic Excel document seems to be selective when moving from
cell to cell. In one cell it works fine and in another it doesn't recognize
an entry found many other times in the document. I've checked the "enable
autofill" box. Any suggestions?