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.

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.