Name Manager
The Name Manager makes working with specific cells or ranges easier by letting you assign custom names and set their scope.
How to Use It
- Click the Named Ranges button in the toolbar.
- A dialog will open.
- Click Add New.
- Input a name to identify the range.
- Set the scope:
- Global: Applies to the entire workbook.
- Sheet-specific: Applies only to the selected sheet.
- Click the check icon to save your changes.
Managing Named Ranges
- Use Edit to modify name, range, or scope.
- Use Delete to remove ranges when they’re no longer needed.