When you work with large amounts of data, it’s easy to lose track of which cells contain which data. In addition, it can be difficult to locate data in workbooks you didn’t create. Although you might always store product prices in one worksheet column, there’s no guarantee that your colleagues will follow the same pattern! One way to prevent confusion is to define a named range for any cell group that holds specific information. For example, in a worksheet with customer order data, you can define the Totals named range to represent the cells in which the total for each order is stored. After you’ve defined the named range, you can display its contents, rename it, or delete it.
For information about selecting cells from several parts of the same worksheet, see "Select a Noncontiguous Group of Cells".
Click the range to which you want to go.
The name you give your named range shouldn’t duplicate a potential cell address. For example, typing DAY1 in a formula would reference cell DAY1. To avoid this problem, either ensure that your ranges have names that begin with at least four letters (the last column is XFD) or use an underscore to separate the letters from the rest of the name. The name DAY1 isn’t valid, but the name DAY_1 is.
3.133.148.105