I could not make your method work. Could you be more explicit about the
steps. I do not understand what you mean by '=" with '_='. Is the
difference between the quotation mark and the apostrophe important, or a typo?

"Arvi Laanemets" wrote:

Hi

Select the row (the range with formulas);
From Edit menu, select Replace, and replace all '=" with '_=';
Copy edited range to new location;
Select both old and new ranges, and replace all '_=' with '='


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"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?