cell text completion

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

Thanks for the info.

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