Spread offers a customizable auto complete (type ahead) feature that can be used
with user entry in editable text cells.
For example, when you type a letter in a highlighted cell, if a match is found the
spreadsheet will show you the suggestions that match. You can change the settings
for auto complete and apply them to any column in the spreadsheet.
First you set the mode for automatic completion, as shown in the figure above. The
options include whether to suggest a list of possible completions, a drop-down list
of possible completions, both, or none.
Second, you can set the source of the suggestions and drop-down list. The source
is the list of items that are considered for completion. You can create a custom
source and define your own list of items or you can set various system sources.