View Single Post
  #1   Report Post  
MLE
 
Posts: n/a
Default Copy WITHOUT adjusting values

How do I copy a row WITHOUT the formulas that reference other rows changing?
E.g., I want to copy row 15 that references say row 10 to a new location, say
row 25. I want the new row to still reference row 10. When I use the
ordinary copy command the new row references row 20.
In my old spreadsheet program, Supercalc, I could choose to "adjust" or
"not adjust" values. How do I do that in Excel?