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!