How to set up automatic calculation of excel tables

EXCEL sets the method of formula automatic calculation: Excel's filling function only needs to input a formula once, calculate a result, and fill it in the drop-down box once, and then the formula can be automatically calculated.

Specific steps: first calculate a cell, and when the result comes out, stand alone in this cell. When you see a black cross in the lower right corner, click and hold it until all cells are filled. Although this method is simple and convenient, if there are too many cells, it may be too slow and easy to make mistakes.

If there are too many cells, you can fill in 1 and 2 cells first, then select 1 and 2 cells, a black cross appears in the lower right corner, and then double-click the button on the left to fill in all the cells behind.