What's the quickest way to multiply multiple cells by another number?

Question

If I have a block of cells such as A1:D5, what's the quickest way of multiplying each cell by another number, 1.1 using Microsoft Excel?

Answer 1

1. Enter the multiplier in a cell
2. Copy that cell to the clipboard
3. Select the range you want to multiply by the multiplier

4. (Excel 2003 or earlier) Choose Edit | Paste Special | Multiply

   (Excel 2007 or later) Click on the Paste down arrow | Paste Special | Multiply

Answer 2

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.

Answer 3

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   500
30      600
35      700
40      800
45      900
50      1000
55      1100
60      1200
65      1300
70      1400
75      1500