In excel, we can quickly calculate the statistical items of the whole data table by drop-down, so how to set up the automatic calculation of Excel drop-down menu? In fact, just set the formula and then drop it down.

How to set automatic calculation of excel drop-down menu;

1. First select the cell to calculate.

2. Then select the calculation mode to use under the formula.

3. Then select the area to be calculated and press Enter to calculate.

4. Then hold down the point in the lower right corner of the cell and drag the mouse down.

5. Finally, release the mouse to automatically calculate the drop-down menu.