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.
