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.