How to average in excel with one click

One-click averaging method in excel: 1. Enter the formula [=average(B2:D2)] in cell E2, double-click the fill handle to copy the formula downward; 2. Hold down the CTRL key and select [ B8:E8] and [E2:E7] two areas, and click the formula to automatically calculate the average.

One-click averaging method in excel:

1. Enter the formula

# in cell E2 ##=average(B2:D2)

Double-click the fill handle and copy the formula downward

2. In the same way, enter the formula in cell B8

=AVERAGE(B2:B7),

Pull the fill handle to the right and copy the formula to the right

3,

Hold down the CTRL key and select the two areas B8:E8 and E2:E7 at the same time, then click on the formula in turn to automatically sum and average

##The results are as follows:

Related free learning recommendations:

excel tutorial

The above is the detailed content of How to average in excel with one click. For more information, please follow other related articles on the PHP Chinese website!