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.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.