[HELP] Auto-complete from entire column after empty cell break.
Hi,
I have a long column of plain text cells (expense categories, so like 5 or 6 different phrases) and I would like Sheets to always auto-complete once I start typing. It works great until I skip a cell. I read elsewhere that after an empty cell, Sheets will try to auto complete from below the active cell. I would like Sheets to auto complete from the entire column disregarding the empty cells. Thank you so much for your help.
WORD -AUTOCOMPLETED
WORD2 -AUTOCOMPLETED
WORD -AUTOCOMPLETED
WORD4 -AUTOCOMPLETED
WORD3 -AUTOCOMPLETED
-empty-
WOR... -WILL NOT AUTO-COMPLETE
Posted Apr 15, 2016, 2:36 AM UTC
21