In a Calc document, a range refers to a contiguous group of cells containing at least one cell. You can associate a meaningful name to a range, which allows you to refer to the range using the meaningful name. You can create either a database range, which has some database-like functionality, or a named range, which does not. A name is usually associated with a range for one of three reasons:
- Associating a range with a name enhances readability by using a meaningful name.
- If a range is referenced by name in multiple locations, you can point the name to another location and all references point to the new location.
- Ranges associated to a name are shown in the Navigator, which is available using the F5 key. The Navigator allows for quick navigation to the associated ranges.