excel autofill not working with filter

The first drop-down list is for column headers the second is for filter types you can choose Text Number Date Year Text format an…