You can see that the formula adjusts the references when I copy and paste it. One of the things that make Excel such a powerful tool is the ability to refer to cells/ranges and use these in formulas.Īnd when you copy these formulas, these cell references can adjust automatically (or should I say automatically).īelow is an example where I copy the cell C2 (which has a formula) and paste it in C3. Shortcut to add $ Sign to Cell References.
