# [Solved:] Excel Double Click AutoFill Not Working

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for the solution to Excel double click AutoFill not working, then you are in the right place. One of the very basic features of Excel is AutoFill. While using Excel, for any kind of calculations or data analysis AutoFill is a must. In this article, weâ€™ll try to discuss Excel double click AutoFill not working.

## Reasons for Double Click AutoFill Not Working

AutoFill works by double clicking the right-bottom corner of the reference cell. It fills the other empty cells according to the calculation or change that has been made in the reference cell. But sometimes double-clicking the reference cell doesnâ€™t activate AutoFill. There may be various reasons for this problem. Those are.

• If the Excel file has a hidden or distant column from the columns filled with data
• If the AutoFill feature is not activated
• In the case of formulas, when the Automatic calculation is turned off.

## Possible Solutions When Double Click AutoFill Is Not Working in Excel

To show the solutions to the problem of AutoFill when double clicked, we have made a dataset named Dataset of Sales. It has column headers as Branch Number, Product A Sale, Product B Sale, Product C Sale, and Total Sale. The dataset is like this.

### 1. When Excel File Has Hidden or Distant Column

One of the main problems we face while using AutoFill by double clicking the right-bottom corner of a cell is when we separate the AutoFill column or hide it from the main continuous dataset, which we have used to get the output in that column.
Suppose, in the following figure, we need to find out Total Sale in Column G. We need to find it by multiplication of Columns C, D, and E. Here, we have used multiplication for a specific type of data analysis, otherwise we might use addition for simple Total Sale.

• The formula in the G5 cell is like this.
`=C5*D5*E5`

• Secondly, we need to double-click the right-bottom corner of the G5 cell to AutoFill the other cells in Column G.

But, unfortunately, it is not working.
The problem is that there is a hidden column which is Column F between Column E and Column G. And 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.
So, double-clicking the right-bottom corner of the F5 cell will give the output now.

Eventually, the output will be like this.

### 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 the AutoFill will not work while double-clicking.

• To enable it, first open the Excel file.
• Secondly, go to File.

• Thirdly, choose Options.

• Eventually, an Excel Options window will appear.
• Fourthly, go to Advanced > select the options which are shown in the picture.
• Fifthly, click OK.

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

Read more: How to Turn Off AutoFill in Excel

### 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. Suppose, 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`

Here, F5 refers to Total Sale.

Now, double-click the right-bottom corner of the G5 cell to AutoFill other cells.

Eventually, weâ€™ll see that all the cells will have the same initial value.
This happens because we havenâ€™t turned on the Automatic Calculation option.

To solve this, firstly, go to Formulas > select Calculation Options > choose Automatic.

Consequently, we have solved the problem and weâ€™ll get the output like this.

## Conclusion

Thatâ€™s all about todayâ€™s session. And these are the ways that the solutions of Excel double click AutoFill do not work. We strongly believe this article would be highly beneficial for you.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF