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:

For more information about each of these, click the appropriate item in the above list.