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