|
1. Select View > Workbook Explorer or press F6 to display the Workbook Explorer.
2. Expand the corresponding workbook node. To expand a node, select the plus symbol to the left of the node name.
3. Right click in the 'Defined Names' node in the worksheet where the defined name will be saved.
4. Select 'New Defined Name' from the context menu.
5. Change the default defined name to a meaningful name if desired.
6. Type the range address that the defined name will refer to.
Notes:
· Defined names can also be created expanding a worksheet node and right clicking in the corresponding 'Defined Names' node selecting 'New Defined Name' from the context menu.
· Defined names can be used to identify a cell, a group of cells, a value or a formula. For example, instead of a range address you can type =2.1226 to refer to the constant value of 2.1226 or =SQRT(5) to refer to the square root of 5.
· The current selected range address will be the default address shown in the 'Refers to' box when a defined name is created.
Related topics:
How to select a range of cells
How to enter formulas in cells
Worksheet functions
|