How to multiply in excel?

Excel multiplication operation method: 1. Select cell C1, enter "=A1*B1", and copy and fill it to [C2:C8]; 2. Select the cell area where the multiplier is located [A1] :A8], press [Ctrl C] to copy; 3. Right-click B1, select "Paste Special", and select "Multiply".

Excel multiplication operation method:

Method 1

1. Select cell C1, enter "=A1*B1", and press Enter to calculate the result of multiplying A1 and B1 in C1.

2. Select cell C1, copy and fill it to C2:C8, you can quickly complete the multiplication of the A2:A8 area and the B2:B8 area.

Method Two

1. The calculation result of Method One is to display the result in cells other than the multiplier. , but sometimes when using multiplication, the result needs to be displayed in the cell within the multiplication.

Select the cell range A1:A8 where the multiplier is located, and press "Ctrl C" to copy.

#2. Right-click B1 and select "Paste Special".

#3. In the Paste Special interface, select "Multiply" and press OK.

4. After selecting the paste command, the result of multiplying the A1:A8 area by the B1:B8 area will be directly displayed in the B1:B8 area.

Related learning recommendations:excel basic tutorial

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