Determining and Using Names in Formulas

Naming formulas in a Microsoft® Excel® workbook makes it easier to maintain them and improves clarity and understanding of the respective data. You can define a name for a cell range, function, constant, or table. Names can easily be updated, audited, and managed once they are defined. In this tip you will learn how to automatically generate names from selected data.

Example exercise – Determining and using names in formulas.

Note: Download the sample workbook to practice this exercise.

Applies To: Microsoft Excel 2007, 2010 and 2013

The screen shot in the example below will be used for this example.






1. Select any cell in the data range A1:H25.

2. Press CTRL + A.

3. Select as per screen shot below.


4. Then select as below.






5. Select OK.

6. The names have been defined as displayed in the name box below.






7. To edit or delete names; select the Name Manager option under the Formulas Tab-Defined Names group and select Edit or Delete.