By using the name range in excel, you can make your formulas much simpler to comprehend better You can assign a name for a range in an excel sheet for a function, for a constant, or a table data Once you start using the names in your excel sheet, you can easily understand these names Define Names For a Selected RangeHere are three ways to create Named Ranges in Excel Method #1 – Using Define Name Here are the steps to create Named Ranges in Excel using Define Name Select the range for which you want to create a Named Range in Excel Go to Formulas –> Define Name In the New Name dialogue box, type the Name you wish to assign to the selected data rangeAfter you define Excel names, you can Use those names in a formula, instead of using a constant value or cell references Type a name, to quickly go to that named range of cells;
How To Assign A Name To A Range Of Cells In Excel