If Excel Autocomplete is not working, you have to check that Autocomplete is not disabled and that there are no Blank cells in the dataset.

This cheat sheet gets you up to speed on the features that were introduced in Excel 2016 and Excel 2019, the perpetual-license versions of Excel included with Office 2016 and Office 2019 ...

You can show or hide list of formulas while typing in Excel with the help of a shortcut key. Press Alt+Down arrow or make it invisible.