Double Click to Fill
Double Click to Fill
The fill function can be double clicked to complete formulas in a range:
Note: The double click needs to detect a recognizable pattern in order to function.
As an illustration, consider employing headers or formulas in the rows or columns adjacent to the data.
Double Click to Fill Example
Let’s compute the Attack B2:B20 + Defense using the double click fill function. For the Pokemon in the D2:D20 range, C2:C20.
- Select D2
- Type =
3. Select B2
4. Type +
5. Select C2
- Hit enter
- Double click the fill function
Well done! After recognizing the pattern, the function finishes the D2:D20 calculation. Keep in mind that it ends at row 20 when there is no more data to compute.
A Non-Working Example
Delete values in the range D1:D20
Enter the formula “=B2+C2” in E2
Note: Columns D and E do not have headers. The spaces between are empty cells.
Double click the fill function.
Waiting…
The fill function does not actually fill the rows; it only loads. It isn’t recognizing the trend.
Give it other hints.
See what happens when you add a header. Add “Atk+def” to E1.
Press the fill function twice.
Still nothing when loading…
Just one more heading. Add “Random” to D1.
Press the fill function twice.
Is the distance closed?
And there we have it! After identifying the pattern, the function filled in the formulas for every row.
The function was able to comprehend the relationships between the data with the addition of headers.
