Auto-Complete in Cells with Data Validation
In a cell with Data Validation, an auto-complete feature would be improve working speed immensely. The feature is there in Google Sheets as well. As long as there are multiple valid items, a drop-down shows a filtered list of such items only. When there is only one item that contains the typed string, pressing Tab or Enter fills that value in the cell and moves to next or below cell respectively. The typed string is matched to be contained anywhere in the valid items list.