How to multiply rows in Excel
Multiplying rows in Excel is a less common task, but there is a simple solution for it too. To multiply two rows in Excel, just do the following:
In this example, we multiply values in row 1 by the values in row 2, beginning with column B, so our formula goes as follows: =B1*B2
.jpeg)
To multiply two columns in Excel, write the multiplication formula for the topmost cell, for example:
=A2*B2
After you've put the formula in the first cell (C2 in this example), double-click the small green square in the lower-right corner of the cell to copy the formula down the column, up to the last cell with data:
.png)
Due to the use of relative cell references (without the $ sign), our Excel multiply formula will adjust properly for each row:
