If I have a block of cells such as A1:D5, what's the quickest way of multiping each cell by another number, 1.1?
+1
A:
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.
Blorgbeard
2009-05-01 00:33:08
and then, if desired, copy the new cells and paste-special-values into the old range (or in place), then delete the cells you don't want.
Carl Manaster
2009-05-01 23:51:00
+2
A:
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.][1]
[1]: http://office.microsoft.com/en-us/excel/HP030561411033.aspx#Multiply a range of numbers by a number
JP Alioto
2009-05-01 00:35:12
+2
A:
- 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
Joel Spolsky
2009-05-01 03:21:15
For this method, you have to create an equivalent shaped range where each cell contains the multiplier and then Paste Special | Multiply the original range onto the multiplier range, I think
barrowc
2009-05-01 23:29:20
+1
A:
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".
Mike Lewis
2009-05-01 03:47:41
I've been doing this backwards: filling a range with the multiplier and Paste Special-ing on to that (see comment to question above). Thanks for this better method
barrowc
2009-05-01 23:36:03