Microsoft Excel: Use Named Constants To Store Numbers

See all Microsoft Excel tips

In this workbook, you can now use a formula such as =SalesTax*D2, as shown in Fig. 213.

If the tax rate changes later use Insert – Name – Define to change the constant assigned to the name.

Summary: To name a constant in a workbook use Insert – Name – Define, type in the name of the constant, and then define the constant in the Refers to: box.

Commands Discussed: Insert – Name – Define

See all Microsoft Excel tips