John Wakenbach has a neat little tool call the Exact Formula Copier in his
Power Utility Pack V6.
http://www.j-walk.com/ss/

It a lot less messier if you have a lot of rearranging to do.

Steve


"MLE" wrote in message
...
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?