Excel automatically inserts previously used words or phrases within a column provided there is no gaps in the column.
Can one
1. get it to predict within the column even if there is a cell with no entry in that column?
2. do the same thing along a row?
3. predict words or phrases anywhere on the sheet?