This function allows you to use the name defined in the reference area when entering a formula. You can define a frequently referenced area with a name to define the area referenced in a formula.
Steps
To use a defined name in a formula
- Enter data in the worksheet as below.
- Select the B1:D5 area and click Formula-Name-Create from Selection.
- In the Create from Selection dialog box, select First Row and click OK.
- Place the cursor in cell B6, then select "Banana" from the submenu of Formula-Name-Use in Formula.
- If "Banana" is inserted in cell B6, enter "=sum(Banana)".
The sum of the constants included in the name defined as Sales Volume will be inserted in the cell B6.
More Information
Paste Names Dialog Box
If you select Paste Names in the Formula-Name-Use in Formula menu, the Paste Names dialog box appears.
Paste Name List
Displays all names defined in the active worksheet. The list displays the name, and reference area of defined names.
If you select a name from the list and click OK, the defined name will be pasted in the form of formula.
Paste Button
Paste all names in the list under the selected cell. The defined name and its reference area will be inserted.
Notes
Typing in cells
When defined names are stored, you can use the names when entering a formula in a cell. If you type “=SUM(Ba” when the name “Banana” is defined, a list of defined names will display as below.
If you select “Banana” from the list, it will be inserted in the formula.