Forcing autocomplete to lookup from a range of cells

[Nick Hebb]

By default, when you're typing in a cell entry, Autocomplete finds
matching entries from the previous entries above in the same column.
Is there a way to force Autocomplete to lookup values from a designated
range of cells?

 

[Dave Peterson]

I don't think so.

Maybe you could use an alternate method--either Data|Validation to choose from a
dropdown.

Or a combobox from the Control toolbox toolbar (which allows you to set the
..matchentry to do the same kind of thing as autocomplete).

 

[Nick Hebb]

I've decided what I'll do is seed the column with a list of valid
entries at the top of the sheet, then hide those rows. Then I can set
my validation list range to the hidden cells. That way, I get the
autocomplete, the dropdown list, and the validation capability.

--Nick