Excel Named range Name Manager - Dynamic named range in Excel.

Name range can be used in formulas as substitute for cell references, To create a names range execute this following steps.

Name Manager (Ctrl+F3) or

Click on the Name Manager. add products on Names and refers to products cells range.

on refers to box select the range that you want to define names.

As above steps create the name for price also.

Once you finish click on OK, below Names Manager box popup will appear here you can do Edit, Delete or New.  

Now you can use this named range in your formulas. For example, sum Price.

Like this you can use this named constant in your formulas. below is the example of lookup formulas

Note: if the price range changes, use the Name Manager to edit the name and Excel automatically updates all the formulas that use Prices.


Do you like this free website? Please follow us on Google+