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.
|