If you're going to include the contents of a cell in several formulas and functions, considering giving that cell a name. Then, simply enter the name in each formula and function. Why? First, a name is easier to remember than a cell reference. Second, copying the formula or function won't upset your formulas and functions. Generally, if you copy a formula or function, Excel uses relative addressing rules to update the new formula. That doesn't happen with a named cell or range; the formula will continue to refer to the named cell. Of course, if you want the formula or function to use relative addressing, you'll need to skip this tip; use this tip only when you want to retain the absolute address. Note: if you have to delete any of the named cells, you will need to make sure to edit the formulas and functions that use them. You will need to replace them with the absolute addresses instead of the names.