Assigning Names to Groups of Cells
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.
Create a Named Range
Select ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
