Note: you could change all cell references to make them absolute, but this tip assumes that you don't want to do that, for whatever reason.
Copy a formula and keep references from changing (Win: Ctrl + X, Ctrl + V Mac: Cmd + X, Cmd + V ) When you cut a formula, it's references do not change. If you moving a formula to a more distant location, use cut and paste. Dragging will keep all addresses intact and unchanged. If you're just moving a formula to a nearby location, try drag and drop. Often this is exactly what you want, because the reuse of formulas is one of the most important techniques of a well-built, easy to maintain worksheet.īut sometimes you need to move or copy a formula to a new location and you don't want the formula to change at all. One of Excel's most powerful features is relative addresses - when you copy a formula to a new location all relative addresses will change. Move a formula and keep references from changing Note: this won't work if your formula contains more than one set of parentheses.Ģ. Excel will add the closing parentheses for you. For example, you can just enter:Īnd press return. Let's start out with something really easy! When you entering one function on it's own (SUM,AVERAGE, etc.) you don't need to enter the final closing parentheses. Don't add the final parentheses to a function Video: 20 tips to save time with Excel formulas 1.
