Setting up a defined name for a formula


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:

  1. Choose Insert, Name, Define to display the Define Name dialog box.
  2. Enter the name you want to use for the formula in the Names in the Workbook edit box.
  3. In the Refers To box, enter the formula exactly as you would if you were entering it in a worksheet.
  4. Click OK.


Please sign in to leave a comment.

Was this article helpful?
1 out of 1 found this helpful