Want to multiply an entire column or range by a number?
You could always use another column and have the formula to do this, but this way is quick and easy if you do not plan on changing the values.
- All you need to do is have the number that you want to multiply in a cell (any cell).
- Now copy this cell and paste as special in the cells/range/column where you want to multiply it.
- In the Paste Special dialog box, choose the multiply option (under operations) and click OK. You’re column/cells/range should be multiplied!
- If desired, can delete the cell that has the value which you multiplied by.
The resulting data is static/fixed so there’s no need to change any formula to value after multiplying using the paste special function.