Take Lenovo Y50p-70-ISE, win 10 system and office20 19 version as examples, and fill a whole column with excel formula. The specific operation is as follows:

1. First, enter the formula in the cell where you want to edit the formula. For example: = "produjct (G 1: H 1) ",and enter the calculation result.

2. Secondly, select the cell where the formula is located and put the mouse in the lower right corner to see a "+"sign.

3. Then, drag the mouse down until the cell to be filled is released, and the calculation result will come out automatically.

In addition to the above methods, you can try the following methods:

Method 1:

1. First, right-click the cell containing the formula and select the copy option.

2. Secondly, select the cell that needs to be filled with the formula, right-click the selected area, and select the Paste Special option.

3. Then, select the formula option and click OK.

Method 2:

First, select the cell that contains the formula and the cell that needs to be filled with the formula.

Secondly, press Ctrl+D to calculate the result.

Method 3:

First, click the name box and enter the range to be filled in, such as D 1: D 100.

Secondly, press enter, click the edit bar, and enter the formula or content to be copied and filled.

Then, press CTRL+ ENTER.

The answer applies to office20 19.