How to use named ranges in formulas in Excel

Using named ranges in formulas saves you a lot of time

In order to define one:

Select some cells,go to menu – insert – named ranges – define