You can enter formulas and functions that contain names of cells/cell ranges/constants/formulas using standard methods.
You can enter a name into a formula or function in the following ways:
•Manually
•By means of a range field
•By means of the Name manager
To enter a name manually, follow these steps:
1.Start typing the name. A drop-down list displays the names that match the search criteria.
2.Select the name using the mouse or keyboard:
•Left-click the name.
•Select the name with the keys ↓ and ↑ and press Enter.
If you want to enter a name using a range field, search for it as described in the Find a name with the range field section.
To enter a name using the Name manager, proceed with the following:
1.Search for a name as described in the Find with Name manager section.
2.Select a name using the mouse or keyboard:
•Select a name by double-clicking.
•Select the name with the keys ↓ and ↑ and press Enter.
The selected name will be inserted into the formula/function. If the name refers to a cell/range, the cell/range will be highlighted in the spreadsheet.