duplicating formulas without updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I should have been specific. I want to do this without using absolute
references.
 
I don't believe you can do that, the only other way I know of would be to
select the range, do edit>replace, 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Duplicates 4
Augmenting an integer in a column to reflect duplicates in another 23
Finding duplicates 2
Comparing text strings 5
Duplicates Formula 3
Can I combine Sumproduct and Countif formula in Excel? Please help 0
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
How to assign unique number to column duplicates? 3

Back
Top