Excel Double Click AutoFill Not Working: 3 Methods

Method 1 – When Excel File Has Hidden or Distant Column

The formula in the G5 cell is like this.

=C5*D5*E5

When Excel File Has Hidden or Distant Column

We need to double-click the right-bottom corner of the G5 cell to AutoFill the other cells in Column G.

excel double click autofill not working

Unfortunately, it is not working.
The problem is that there is a hidden column which is Column F between Column E and Column G. We are trying to calculate and get all the outputs by using AutoFill in Column G which has discontinuity with the continuous dataset. The AutoFill column must be continuous with the dataset to work properly.

The solution for this is that if we calculate in Column F instead of Column G, we will have a continuous dataset, and this time, the AutoFill Shortcut feature will work properly.
Double-clicking the right-bottom corner of the F5 cell will give the output now.

The output will be like this.

excel double click autofill not working

Method 2 – Fill Handle Feature Is Not Enabled

We need to ensure first if the Fill Handle feature is enabled or not. Without enabling the Fill Handle feature, AutoFill will not work while double-clicking.

Go to File.

Fill Handle Feature Is Not Enabled

Choose Options.

excel double click autofill not working

An Excel Options window will appear.
Go to Advanced > select the options which are shown in the picture.
Click OK.

excel double click autofill not working

By doing this, we have enabled the Fill Handle feature, and the AutoFill feature will work by double-clicking

Method 3 – When Automatic Calculation Is Turned Off

AutoFill feature will also not work in the case of calculation if we don’t turn on the Automatic Calculation option. We have the following dataset where we need to find the Profit considering 30% of the Total Sale.
Firstly, we got the Profit in the G5 cell using the formula.

=F5*0.3

F5 refers to Total Sale.

When Automatic Calculation Is Turned Off