How to Name a Cell Range in Google Sheets
Cell references can be confusing, especially when you're working with formulas. However, cell and range names can help. You can define a name for a single cell or a range of cells.
The Named Ranges pane opens. If you had any cell ranges named already, they'd be listed here.
The cell range is named. Now, when you create a formula, use the name to reference the cell(s) instead.
Now when we enter a formula, we can use the cell name instead of its column and row coordinates.
You can also use named ranges to make it easier to navigate a workbook.
Sheets takes you to your named cell or cell range.
You can easily edit, rename, and delete cell range names.
Here, you can change a range's name or adjust the cell range. You can also delete a range you no longer need.
Just to be sure, you're asked before it's deleted.
The pane closes. Remember that once a named range is removed, you'll need to update any formulas using that range with the correct cell range.