Formulas become much easier to understand and maintain when we use names instead of cell/range references. For example, for clarity purpose, the range (A1
To use name in formulas, follow these steps:
1- Click a cell, having a formula and select the part of the formula that you want to name.
2- In the Formulas tab, go to the Defined Names section and click on the Use in Formula.
3- Select a name and press Enter.
Manage names in your workbook with Name Manager
To create, edit, delete and find all the available