Can I set up a defined name for a formula in Microsoft Excel?
Yes, you can!
You can apply the naming concept for frequently used formulas; the formula doesn't physically have to appear in a cell, and this not only saves memory, but it often makes your worksheets easier to read as well.
Follow these steps to name a formula:
- Choose Insert, Name, Define to display the Define Name dialog box.
- Enter the name you want to use for the formula in the Names in Workbook edit box.
- In the Refers To box, enter the formula exactly as you would if you were entering it in a worksheet.
- Click OK.