Engineers-Excel.com

Using Defined Names



Names can be defined in Excel to store a fixed value or a formula. A cell or a range of cells can be given a name by:

a. Selecting the range and keying in the name into the Name Box; or

Naming a cell

b. Using the Insert Menu and choosing Name / Define in Excel 2003, or Formula Tab and 'Define Name' in later versions.

Defining names

Once the name is defined, it can be used in the sheet. In the screen shot below, the name is being used in a formula to find the weight of an object, given its mass.

Using names

Names can also contain formulae. In the name box below, the weight of the object is evaluated in the name weight using the stored values gravity and mass. This is useful when the result is required at multiple locations a worksheet.

Named formula

Using named formulae