cell text completion

G

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
 
G

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
 
G

Guest

Thanks for the info.

Gord Dibben said:
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
Click to expand...
 
Top