Why You Should Be Using Named Ranges In Excel
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> Create from Selection Excel has calculated a different result for each use of the named range A warning It is not possible to create a 'global' relative named range In each of the examples above, the name of the sheet is used to define the named range, so there needs to be new relative named ranges for each worksheet
