Naming cells and ranges

Cells and ranges of cells can be assigned names. After a cell is named, you can use the name instead of the cell address in formulas and other references to that cell.

For example, supplies might be one expense category and utilities another. By giving names to the grand total cells for both supplies and utilities, you can build a formula that looks like this:

=SUPPLIES+UTILITIES

In addition, you might find it easier to remember SUPPLIES than a precise cell address. So, if you want to use the Go To command from the Edit menu to move the cursor to that cell, you can simply enter the name SUPPLIES rather than a cell address.

See:

Assigning names to cells and ranges