Excel: Use Named Constants to Store Numbers

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I've seen how to assign a name to a cell. Is it also possible to assign a name to a constant? That could be useful for a number, such as a local sales tax rate, that changes periodically.

Strategy: Yes, you can assign names to constants. To do so, you follow these steps:

  1. Select Formula, Define Name.
  2. In the New Name dialog, type a name such as SalesTax in the Name text box. In the Refers To box, type 0.065 and then click OK.
  3. In this workbook, you can now use a formula such as =SalesTax*D2.

  1. A defined name holds 6.5%.
    1. If the tax rate changes later, select Formulas, Name Manager. In the Name Manager, select the constant's name and click Edit.

For more resources for Microsoft Excel