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.

image with no caption

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 instance, you can group the items from the preceding graphic into a range named NortheastLastDay. Whenever you want to use the contents of that range ...

Get Microsoft® Office Home and Student 2007 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.