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.

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.

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.

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.