Naming cells
Instead of referring to a cell by its coordinates, such as B10, you can assign it a name. Creating a cell name has several advantages. First, if you move the contents of a named cell, the name is still associated with the same data, regardless of the new coordinates. Second, referencing names in a formula makes the formula easier to understand. For example, +PRICE – COST is more intuitive than B15 – D8. As well, using names increases accuracy. If you mistype a name, Quattro Pro alerts you to the error. If you mistype coordinates, you operate on the wrong cells.
You can change the cells assigned to a name. You can also name cells using adjacent labels.
Quattro Pro can name cells automatically. You can create a two-column table that lists all of the named cells in a notebook with their corresponding coordinates. And, if you no longer want to identify a cell or block of cells by a name, you can delete that name.
For additional information about naming cells, see “Guidelines for naming cells.”
To create a cell name |  |
|
1.
|
|
Select a cell.
|
|
2.
|
|
Click Insert
 Name Name cells. |
|
3.
|
|
Type a unique name in the Name box.
|
|
4.
|
|
Click Add.
|
To change the cells assigned to a name | |
|
1.
|
|
Click Insert
Name Name cells. |
|
2.
|
|
Choose a name from the Name list.
|
|
3.
|
|
Type the new coordinates in the Cell(s) box.
|
|
4.
|
|
Click Add.
|
To name a cell from an adjacent label | |
|
1.
|
|
Select a label.
|
|
2.
|
|
Click Insert
Name Name cells. |
|
3.
|
|
Click Labels.
|
|
4.
|
|
In the Direction area, enable an option to indicate the position of the cell being named in relation to the selected label.
|
|
For example, if the cell you are naming is below the label, enable the Down option.
|
|
•
|
|
Each label in the specified cells (up to 64 characters) is used as a name. Numeric values in the selection are ignored. Later changes to original labels do not affect the cell names.
|
|
•
|
|
Any leading or trailing spaces in a label are included in the name.
|
To name cells from labels automatically | |
|
1.
|
|
Click Insert
Name Name cells. |
|
2.
|
|
Click Generate.
|
|
3.
|
|
In the Generate cell names dialog box, type the cells to name, including label cells, in the Cells box.
|
|
4.
|
|
In the Create cell names area, enable any of the check boxes.
|
|
•
|
|
Each label in the specified cells (up to 64 characters) is used as a name. Numeric values in the selection are ignored. Later changes to original labels do not affect the cell names.
|
|
•
|
|
For additional information about automatically naming cells, see “Guidelines for naming cells.”
|
To create a table of named cells | |
|
1.
|
|
Click Insert
Name Name cells. |
|
2.
|
|
Click Output.
|
|
3.
|
|
In the Name table dialog box, type in the Cells box the top-left cell of the cells where you want the table to display.
|
|
•
|
|
Make sure there is enough room for a two-column table, with one row for each name. Existing data in the cells used for the table is overwritten by the table.
|
|
•
|
|
A named cell table is not automatically updated. If you add, change, or delete cell names, you must re-create the table to reflect the changes.
|
To delete a cell name | |
|
1.
|
|
Click Insert
Name Name cells. |
|
2.
|
|
Choose a name from the Name list.
|
|
3.
|
|
Click Delete.
|
|
•
|
|
Although clicking Delete deletes the cell name from memory, the notebook data is not affected. Formulas that reference the named cell change so that they refer to cell coordinates instead.
|