SUMMARY OF PROCEDURES FOR THE EXCEL READING LIST …

If you want to “lock down” the row reference in a formula to prevent it from changing when the formula is copied and pasted into other cells, insert a $ before the row reference in the original formula before copying and pasting (e.g., a cell reference of C$7 prevents the row reference from being altered to anything other than row 7 while ... ................
................