Cell Range Names

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.

Use a Cell Range Name in a Formula

1. Enter a formula using the cell range name instead of the cell range.
   

Now when we enter a formula, we can use the cell name instead of its column and row coordinates.

Go To a Named Range

You can also use named ranges to make it easier to navigate a workbook.

1. Open the Named Ranges pane.
2. Click a named cell range.
   

Sheets takes you to your named cell or cell range.

Edit and Delete Cell Range Names

You can easily edit, rename, and delete cell range names.

1. Open the Named Ranges pane.
2. Click a named range's Edit button.
   

   Here, you can change a range's name or adjust the cell range. You can also delete a range you no longer need.

3. Edit a named range's name or range, or click Delete.
   

   Just to be sure, you're asked before it's deleted.

4. Click Remove.
   
5. Close the Named Ranges pane.
   

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.