Method 1: Fill with fill handle.
1. In the spreadsheet, select the cell filled with the formula.
2. Move the mouse to the lower right corner of the cell. When the mouse becomes a black cross, click the left button.
3. Drag the mouse to the area to be filled.
Method 2: Fill in with shortcut keys.
1. In the spreadsheet, select the cell filled with the formula.
2. use Ctrl+C to copy this formula.
3. Select the area to be filled, and then use Ctrl+V to paste. The result of pasting is to automatically fill in the formula according to the size of the selected area.
Precautions:
1. Make sure that the filled area is consistent with the cells that have already filled in the formula, otherwise the formula may be filled in incorrectly.
2. If you need to change the size of the filled area, you need to delete the formula in the filled area before refilling.