Microsoft Office Tutorials and References
In Depth Information
Naming groups of data
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter03 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.
Naming groups of data
When you work with large amounts of data, it’s often useful to identify groups of cells that
contain related data. For example, you can create a worksheet in which cells C3:I3 hold the
number of packages Consolidated Messenger’s Northeast processing facility handled from
5:00 P.M. to 12:00 A.M. on the previous day.
Instead of specifying the cells individually every time you want to use the data they contain,
you can define those cells as a range (also called a named range ). For example, you can
group the items from the cells described in the preceding paragraph into a range named
NortheastPreviousDay . Whenever you want to use the contents of that range in a
calculation, you can simply use the name of the range instead of specifying each cell individually.
TIP Yes, you could just name the range Northeast , but if you use the range’s values in a
formula in another worksheet, the more descriptive range name tells you and your colleagues
exactly what data is used in the calculation.
To create a named range, select the cells you want to include in your range, click the
Formulas tab, and then, in the Defined Names group, click Define Name to display the New
Name dialog box. In the New Name dialog box, enter a name in the Name field, verify that
the cells you selected appear in the Refers To field, and then click OK. You can also add a
comment about the range in the Comment field and select whether you want to make the
name available for formulas in the entire workbook or just on an individual worksheet.
Search JabSto ::

Custom Search