Microsoft Office Tutorials and References
In Depth Information
Practice Files Before you can complete the exercises in this chapter, you need to copy
the book’s practice files to your computer. The practice files you’ll use to complete the
exercises in this chapter are in the Chapter03 practice file folder. A complete list of
practice files is provided in “Using the Practice Files” at the beginning of this book.
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 C4:I4
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, type 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.