How to Use Absolute References to Keep Formula Copies Working
When you copy a formula to another cell in Excel, it does not copy the actual cell references. Instead, it keeps the spatial relationship of the cells in the formula. Say that a cell sums the two cells to its left (e.g., Cell C2 contains the formula =A2+B2). Copies of that formula will always sum…