In Excel, a name can be global to a workbook or local to a worksheet The traditional method we all use when we create a range name usually creates global names But when we work with dashboards we set up each chart to be supported by its own worksheet These worksheets are very similar, with many names in commonLess You can quickly create a named range by using a selection of cells in the worksheet Note Named ranges that are created from selecting cells have a workbooklevel scope Select the range you want to name, including the row or column labels Click Formulas >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
Working With Range Names In Formulas Building Basic Formulas In Excel 16 Informit
