All About Excel Named Ranges Excel Range Name
Create a named range or a named constant and use these names in your Excel formulas This way you can make your formulas easier to understand To create a named range, execute the following steps 1 Select the range A1 2 On the Formulas tab,A named range is just a humanunderstandable name for a range of cells in Excel 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
