Autocomplete on part of a sheet

[ChasH]

Is it possible to have autocomplete operational on just
part of a spreadsheet (i.e. on just one column, or a
range of columns) ??

Any help would be greatly appreciated

 

[Andy B]

Hi

AutoComplete relies on the fact that the data above, which it uses to
autocomplete, is in one contiguous range. This means that if you insert a
blank row (and hide it if necessary) the AutoComplete will ignore the
section above. Whether this information is of use to you I don't know!