For some users, AutoFill is not working in Excel. This article lists some solutions that will help you fix this problem. Why is my Fill series not working?

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.