Auto Fill Option In Excel Not Working. To make it work you must have the value in the adjacent cell so excel will understand till what row or column it must fill down. Try removing all filters and dragging again.
You might also run into drag to fill issues if you re filtering. I do have the small black square in the bottom right of the cell that i can click on and pull down numerous rows and it will fill the cells with the same number. Similarly if the button does not show when you use the fill handle you can turn it on.
There is no option to re enable the table autofill formulas option.
To make it work you must have the value in the adjacent cell so excel will understand till what row or column it must fill down. Auto fill options box missing. Click or tap ok to save the changes and. In general it is not a good idea to deactivate autofill option.
