Computer: MacBook
System: OSX 10.9
Software: Excel20 13
1. Create a new Excel spreadsheet and enter operations in the Excel spreadsheet to demonstrate how to perform batch multiplication in the Excel spreadsheet. As shown below, columns C, D and E are multiplied by 10 in batches.
We know that the way to get the product of two numbers is to multiply the two numbers. Mathematically, the formula is c=axb. Similarly, we also use this method in excel, but the details have changed. Find a cell and enter the value of the multiplicand.
3. After clicking Enter, we can get the product of A 1 and B 1 in the cell C 1, and then put the mouse in the lower right corner of the cell C 1. When the mouse changes to a black solid cross shape, double-click the mouse or hold down the mouse and drop it down to fill in the column value. Select the cell where the multiplicand is located, right-click, and then click Copy.
4. Select the area where data needs to be multiplied in batches.
5. Click to select cell C 1, enter "A 1 and B 1" formulas in the formula editing field, and then click Enter on the keyboard. Right-click, click Paste Special, and then click Multiply.
6. In this way, we can see that the product of column A and column B is calculated by formula, and the corresponding value is placed in column C ... that is, the result is obtained.