Dear MLE,

Pls write '$' sign before the ref: ie

=a$15 for freezing row 15
or
=$a$15 for freezing row and coloumn

anirudh

"MLE" wrote:

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?