Рет қаралды 7,432
You can enter named ranges in formulas which allows to use meaningful names in the formulas, making your formulas easier to understand. You can enter named ranges in formulas in three ways, the easiest way is to select the named range from the drop down list Excel displays when you type a formula. You can press F3 and if there are any named ranges Excel displays "Paste Name" dialogue box and you can select the named range. You can also click on "Use in Formula" in the "Define Names" group in the ribbon and select the named range.