Home |
Search |
Today's Posts |
#1
|
|||
|
|||
duplicating formulas without updating
How can I select a row of cells that contain formulas, duplicate them, and
paste them elsewhere without them updating, a la moving them with the mouse, but with duplication. |
#2
|
|||
|
|||
Use absolute reference, i.e. if a formula looks like
=H5*H6 use =$H$5*$H$6 Regards, Peo Sjoblom "Wazooli" wrote: How can I select a row of cells that contain formulas, duplicate them, and paste them elsewhere without them updating, a la moving them with the mouse, but with duplication. |
#3
|
|||
|
|||
I should have been specific. I want to do this without using absolute
references. "Peo Sjoblom" wrote: Use absolute reference, i.e. if a formula looks like =H5*H6 use =$H$5*$H$6 Regards, Peo Sjoblom "Wazooli" wrote: How can I select a row of cells that contain formulas, duplicate them, and paste them elsewhere without them updating, a la moving them with the mouse, but with duplication. |
#4
|
|||
|
|||
I don't believe you can do that, the only other way I know of would be to
select the range, do editreplace, find = replace with r= (replace the equal sign with something), copy the selection and paste it, select both ranges and reverse the the replace. Regards, Peo Sjoblom "Wazooli" wrote: I should have been specific. I want to do this without using absolute references. "Peo Sjoblom" wrote: Use absolute reference, i.e. if a formula looks like =H5*H6 use =$H$5*$H$6 Regards, Peo Sjoblom "Wazooli" wrote: How can I select a row of cells that contain formulas, duplicate them, and paste them elsewhere without them updating, a la moving them with the mouse, but with duplication. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
duplicating excel formulas | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |