Autocomplete or "Pick from list" gets its information from cells above and
below the point in the same column that you are entering new data.

If this data is disturbed by blank cells above or below, the Autocomplete
can/will fail.


Gord Dibben Excel MVP

On Sat, 8 Oct 2005 20:40:32 +0100, nospam wrote:

Hi,

I am making an index of worksheets tat I use for my pupils.

When I type in some cells excel offers me some text that is in previous
cells in the column.

Some other columns don't offer me this option.

Is it possible to make all columns offer me this option?

Thanks