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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

If it doesn t need to be a macro  then just put  A1 1 1 into  say  D7  then drag the formula fill handle across  then down

User · Answer

As one of the answers above says    then drag the formula fill handle    This KEY feature is not mentioned in MS s explanation  nor in others here   I spent over an hour trying to follow the various instructions  to no avail   This is because you have to click and hold  near the bottom of the cell just right  and at least on my computer that is not at all easy  so that a sort of  handle  appears   Once you re luck enough to get that  then carefully slide   drag   your  cursor down to the lowermost of the cells you want to be multiplied by the  constant   The products should show up in each cell as you move down   Just dragging down will give you only the answer in the first cell and a lot of white space

User · Answer

Put the number you want to multiply by in a cell that is not in your range  Select the cell and  Copy  it to the clipboard  Next  select the Range A1 D5  and from the menu choose Edit Paste Special  A dialog box will appear  In the  Operation  area  select  Multiply  and click  OK

User · Answer

Select Product from formula bar in your answer cell   Select cells you want to multiply

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

Examples related to vba

Examples related to excel

Examples related to excel-formula