What's the quickest way to multiply multiple cells by another number?
- Enter the multiplier in a cell
- Copy that cell to the clipboard
- Select the range you want to multiply by the multiplier
(Excel 2003 or earlier) Choose Edit | Paste Special | Multiply
(Excel 2007 or later) Click on the Paste down arrow | Paste Special | Multiply
Are you asking how to do it in excel or how to do it in a VBA application? If you just want to do it in excel, here is one way.
To multiply a column of numbers with a constant(same number), I have done like this.
Let C2
to C12
be different numbers which need to be multiplied by a single number (constant). Then type the numbers from C2
to C12.
In D2
type 1 (unity) and in E2 type formula =PRODUCT(C2:C12,CONSTANT)
. SELECT RIGHT ICON TO APPLY. NOW DRAG E2
THROUGH E12
. YOU HAVE DONE IT.
C D E=PRODUCT(C2:C12,20)25 1 50030 60035 70040 80045 90050 100055 110060 120065 130070 140075 1500