[Naming cell ranges]

Naming cell ranges, so that we can use them in formulas:

·         First of all we have to select the cells that we want to name

·         After that, on the formula tab, click  the Define Name Button

·         Enter a specific name in the Name box

·         And finally, on the Scope drop-down list, we choose Workbook or a Worksheet name

We can also add a descriptive comment for the range name, such that we can rememeber the type of information the cell hold.

After that we can actually use the cell range name in a formula (or simply press F3, even more quickly is to open the Name box drop-down list and choose a name)

If we decide later that we want to change the name of the cell, or simply  we do not need it anymore, all we have to do is to click the Name Manager button on the Formulas Tab.