# Paste Special Multiply

#### EdE

##### Board Regular
How do I use paste special/multiply so that when I copy a cell then multiply, it uses the cell reference instead of the number in that cell. I.E. I have in A5, =a3, and in a1 have 25, but I want in a5, =a3/a1. I ask because I have several thousand formulas to modify to add/divide/multiply by only 3 different cells. Or is there an easier way to do this?

Thanks!

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
could you be a little more clear. Having a hard time understanding what you actually need to do - I do get the prospect of changing a zillion cells - not fun

I don't think that Paste Special (divide, not multiply in your case) can do what you want... you would have to use a macro to change the cells you specify.

I have rows of formulas that currently do various calculations. Now some of these formulas must make the same calculation and divided by a value that can be changed. I.E.
Now-->a4+a5 Needs to be (a4+a5)/a1.
Does this make sense? Or is a massive find/replace in order?
Thanks?

Yes, look at my post... Find / Replace shouldn't work because, unless your formulas were constructed with a pair of ( ) at the beginning and end of each formula, you would screw them up ! because this

=A4+A5

would be converted as

=A4+A5/A1

=(A4+A5)/A1

If you follow these steps this should work.
Put an odd number in a1 (like 2.11111)
Use find (in formula) to search for any other instances of 2.11111 (if there are any choose a different number).
Copy a1, and paste special divide over your range.
Now use find and replace over the same range and find 2.11111 and replace with A1.

Thanks. I thought I could use the paste special function. What I did to resolve was highlighted the entire section I needed to change, F2, made my changes, then ctrl+enter. Worked pretty good. About as efficient I guess.

Replies
2
Views
261
Replies
6
Views
486
Replies
5
Views
768
Replies
15
Views
429
Replies
7
Views
177

### Forum statistics

1,221,052
Messages
6,157,632
Members
451,426
Latest member
VinnyDoesntKnowExcelCode

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back