Define names for cells, formulas, or constants

1. On the spreadsheet toolbar, click Commands and Options , and then click the Formula tab.
2. Under Names, type the name you want to use in the Name box.

   If you want to define a name that is available to only one sheet (a local name), precede the name you want to use by the sheet name followed by an exclamation point. For example, if you want to name a cell Budget, and make it available only on Sheet2, type the following in the Name box:

   Sheet2!Budget

3. In the Refers to box, type = (equal sign), followed by the formula, constant value, or reference to the cell or range of cells you want to name. For example, to name cells A1 through A5 on Sheet1, type the following:

   =Sheet1!$A$1:$A$5

4. Click Define.