Formulas and functions that contain cell names, ranges, arrays, constants, or formulas are entered using standard methods.
You can enter a name into a formula or function in the following ways:
–Manually
–Using the range field
–Using the Name manager
To enter the name manually, follow these steps:
1.Start typing the name. The names corresponding to the search criteria will be displayed in the drop-down list.
2.Select a name using your mouse or keyboard keys:
•Left-click on the name.
•Select the name using the ↓ and ↑ keys on your keyboard and press Enter.
To enter a name using a range field, search for it as described in Find a name using the range field.
To enter a name using the Name manager, do the following:
1.Search for a name as described in Find using Name manager.
2.Select a name using the mouse or keyboard keys:
•Select a name by double-clicking.
•Select the name using the ↓ and ↑ keys on your keyboard and press Enter.
The selected name will be inserted into the formula or function. If the name belongs to a cell, range of cells, or range-based array, then the cell, range, or array is highlighted in the spreadsheet.