I believe many friends know that you can copy formulas by dragging the fill handle. If you want to copy fewer rows, it is acceptable to copy the formula by dragging the fill handle, which is inconvenient if you want to copy too many rows. Let me introduce you to a convenient and quick way to copy a formula by double-clicking the fill handle to copy the formula.
I share this technique with my friends by using an example of a simple quick copy formula.
A, B, C represent a group of numbers, each group of 100, in the form of a, B, c the number represented by the formula "A+B-C" calculated, and displayed. Enter the number of a, B, and C you want to calculate in the table first, and then enter the formula "=A2+B2-C2" at Cell D2, and then use any other location with the mouse when you enter the formula, and the results are displayed at cell D2.
What about the remaining numbers to be calculated according to the formula "A+b-c"? One input to the corresponding formula, which is too troublesome and the stupidest method; Drag the fill handle at the cell D2, but with so many groups, it's cumbersome. A simpler and quicker way to do this is to double-click the fill handle at the cell D2.
With cell D2 selected, move the mouse over the padding handle at the lower-right corner of the cell, as shown in Figure 1:
The mouse turns black cross, double click, look, the remaining number of all according to the formula "A+b-c" calculate well, see Figure 2:
It's very convenient and quick.
In fact, double-click the mouse can not only quickly copy the formula, can be used to quickly fill the column, and the left key drag fill handle effect, just in the column to fill the previous column to have content, the previous column of the contents to which row, double-click the fill handle will be automatically filled to the line. Looking at the 3,d column is the data that is automatically populated by double-clicking the fill handle at the cell D1, and the same row in column C is no longer populated.