Named Ranges

Naming Ranges allows you to select an area on the grid and to name it. You can do this from the "Edit names..." option on the "Data" menu.

How to use named ranges

For the formulae in your spreadsheet, this gives you a way to make things more readable; instead of writing =SUM(A12:Z12) you can write =SUM(monthlySales).

For your Python code, this gives you a way to define a variable referencing a CellRange. The variable is global, and is defined in the "Constants and Formatting" section of the code.

How to define named ranges

Select a range in the grid.
Select the "Edit names..." option on the "Data" menu.
In the dialog that appears, you will see a list of the names that have been defined so far, with buttons to add new ones and delete existing ones.
Hit the "Add" button. A new line will appear in the list; you can enter the name and you can adjust the reference (that is, the range) to which it refers. Please note that the reference must be absolute and the name must be distinguishable from a cell reference (so you can't have a named range called, say, A1).
Once you have finished entering your named range, hit "OK" to apply the change and close the dialog.

Comments

If you have comments, questions or suggestions about any of the Resolver One documentation, please post them to the Documentation Suggestions Forum.