Excel Double-Click to Fill

Double Click to Fill

The fill function can be double-clicked to complete formulas in a range:

Double Click to Fill Example

Let's use the Double click fill function to calculate the Attack B2:B20 + Defense C2:C20 for the Pokemons in the range D2:D20.

1. Select D2
2. Type =

Name Attack Defense Caterpie 30 35 Metapod 20 55 Butterfree 45 50 Weedle 35 30 Kakuna 25 50 Beedrill 90 40 Pidgey 45 40 Pidgeotto 60 55 Pidgeot 80 75 Rattata 56 35 Raticate 81 60 Spearow 60 30 Fearow 90 65 Ekans 60 44 Arbok 85 69 Pikachu 55 40 Raichu 90 55 Sandshrew 75 85 Sandslash 100 110

Copy Values

3. Select B2
4. Type +
5. Select C2

6. Hit enter

7. Double-click the fill function

Way to go! The function understands the pattern and completes the calculation for D2:D20. Note that it stops when there is no more data to calculate, at row 20.

A Non-Working Example

Delete values in the range D1:D20

Enter the formula "=B2+C2" in E2

Double-click the fill function.

Waiting...

The fill function is just loading without filling the rows. It does not understand the pattern.

Give it more clues.

Add a header to see what happens. Enter "Atk+def" in E1

Double-click the fill function.

Loading... Still nothing...

One more header. Enter "Random" in D1

Double-click the fill function.

Is the gap closed?

There we go! The function recognised the pattern and filled in the formulas for each row.

Adding headers helped the function to understand the relationship between the data.