Named ranges are a useful, but often underutilized, feature of Microsoft Excel Named ranges can make formulas easier to understand (and debug), simplify the creation of complicated spreadsheets, and simplify your macros A named range is just a range (either a single cell, or a range of cells) to which you assign a name 2 I have never seen a local range name being created by defining the same name twice, the second time simply overwrites the first definition Copying a sheet effectively creates local range names for all global ones pointing to the original sheet Create Range Names 1 Select a range of cells in your spreadsheet (for example, in our sample, select B4B13) 2 From the Formulas tab, click Define Name 3 Notice that Excel
Excel Names And Named Ranges How To Define And Use In Formulas