Define & use names in Excel formulas. You can define a name for a cell range, function, constant, or table and once you become familiar with the technique, you can easily update, audit or manage ...

2. From the Formulas tab, click Define Name.. 3. Notice that Excel has already entered the column/field name of the range you highlighted (even though that cell was not included in your range).