Autocomplete on part of a sheet

  • Thread starter Thread starter ChasH
  • Start date Start date
C

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
 
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!
 
Back
Top