Auto-enter in spreadsheets?

[anotheoldgit]

When I enter an item in a column of an exel spreadsheet whose name has previously been entered before, after the first two or three letters of the word having been typed in, the whole word automatically appears.

This facillity only takes place in a column of items. How can I make it work over the whole spreadsheet? In other words once typed into any cell of the spreadsheet a word will auto-enter into any cell or column over the whole spreadsheet, after the first letters have been entered.

[kempie]

Excel's built in AutoComplete feature will only match previously entered data within cells of the same column.