In this article, I share some good tips to save you time when working with formulas in Excel. When you entering one function on it's own (SUM, AVERAGE, etc.) you don't need to enter the final closing parentheses. One of Excel's most powerful features is relative addresses — when you copy a formula to a new location all relative addresses will change.For example, you can just enter: =SUM(A1: A10 and press return. 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.Excel uses this data to figure out how far down the worksheet to copy the formula. If the selection is not too large, you can also fill formulas down a worksheet using the shortcut for Fill Down (Control D).Just make sure to select the original formula and the target cells first.
Dragging will keep all addresses intact and unchanged.If you just need to copy a single formula, select the entire formula in the formula bar and copy to the clipboard. The result will be a formula identical to the original.