There are two ways you can add the $ sign to a cell reference in Excel. Shortcut to add $ Sign to Cell References
Now you can use the dollar ($) sign in three different ways, which means that there are three types of references on Excel. When you use a $ sign before the cell reference (such as $C$2), you’re telling Excel to keep referring to cell C3 even when you copy and paste the formula. What if you want to copy the formula, but don’t want the cell reference to change? This is called relative reference where the references adjust based on the cell in which it has been applied.īut what if you don’t want some cells to adjust the reference? While in the formula in cell C2 refers to A2 and B2, the one in C3 refers to A3 and B3.
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.
