In Excel (and other spreadsheets), most of the time we refer to a cell or a range by using it’s address, for example A1 or A1:B10. However, assigning a “name” to a cell or range provides a number of benefits.
The quickest way to assign a name to a cell or range is to select the cell/range, click in the “Name Box” which is just above the column headings, type the desired name (which must start with a letter and cannot contain spaces) and press Enter.
There are numerous benefits of using cell names. These include:
- Quick Navigation
- As an Alternative to using Absolute References
- To ensure that a macro won’t “break” when a user adds/deletes rows/columns or moves data around
For more information about each of these, click the appropriate item in the above list.