[HELP] Auto-complete from entire column after empty cell break.

Waiting on OP

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
Loading comments…