screenshots demonstrate what happens when a formula containing absolute row
references is copied. The references
found in cell E2 contain the same row numbers as the references in cell D2,
but the Column letters are different. Dollar signs before the row numbers
cause the row references to remain constant after being copied.