Auto Fill Option In Excel Not Working. This is occurring on a single worksheet of a workbook file. 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.
This is occurring on a single worksheet of a workbook file. When the quick analysis is disabled by going to file options general it also disables the auto fill from showing despite enabling the fill handle and cell drag and drop under file options advance. There is no option to re enable the table autofill formulas option.
In excel 2019 2016 2013 and 2010 navigate to the file options menu.
In the excel options window open advanced on the left. To re enable table autofill formulas you must use the proofing option as shown below. 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.
