Assigning names
To assign a name to a range of cells:
| 1. | Select the cell range that you want to name. |
| 2. | Choose the ribbon command Formula | group Named areas | Edit names  . |
| 3. | Input a name for the cell range in the input field Name. |
| 4. | Click the Add button. |
You have now assigned the specified name to the selected cell range.
From now on, this name can be used in formulas instead of the original cell addresses. If you assign the name "January" to the cell range from A2 to A10, the formula =SUM(January) is equivalent to =SUM(A2:A10).
Note: Names may only consist of alphanumeric characters, underscores and periods. The first character must be a letter or an underscore.
Furthermore, names that look like a cell address must not be used. For example, the name "A2" is not valid because PlanMaker wouldn't be able to distinguish it from the cell address A2.
Tip: A faster method
There is a faster method for assigning names to cell addresses:
In the top left corner of the worksheet is an editable dropdown list that normally displays the current cell address.
Use this dropdown list to quickly set up a new named range, as follows:
| 1. | Select the cell range that you want to name. |
| 2. | Click with the mouse in this editable dropdown list. |
| 3. | Enter the new name for the selected cell range. |
| 4. | Press the Enter key↵. |
You have now assigned the specified name to the selected cell range.
Renaming or deleting names
To rename or delete a named cell range, proceed as follows:
| 1. | Choose the ribbon command Formula | group Named areas | Edit names . |
| 2. | In the list of names, select the desired name. |
| 3. | To rename it, click the Rename button. To delete it, click the Delete button. |
The name has now been renamed/deleted.
Note: When you delete a name, all formulas that use this name will now return a #NAME? error value instead of a result. If, for example, a cell range was named "January", all references to this named range, such as =SUM(January), will display a #NAME? error value.