excel
 

How multiply more cells in same time

excel
 

Put the value to multiply by in a spare cell, and copy that cell.

Select the range to be multiplied.

Goto editPasteSPecial and select Multiply.

Exit and clear that first cell.

---
HTH

Bob Phillips

"a" wrote in message
...
How multiply more cells in same time

Multiply many cells
 

Hello!

If you want to multiply a row or a column with the same number, you can:

1) put the number you want to multiply in a different row/column

2) select the row/column beside the original row/column you want to multiply

3) then Assuming the column A is the original row, you can put this formula:

=A1*$C$1

Where A1 is the cell on the original column, then C1 is the number you want to multiply it with. You use the dollar sign so that when you copy and paste, the reference cell will not change.

4) Just either copy paste the formula until the end of the column, or just click, hold, and drag the lower right side part of the cell (which is in a shape of a box)


For more tips on excel and financial models, you can check this out. Hope this helps!