• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Working with Named Ranges > Managing Named Ranges

Managing Named Ranges

Named ranges, which represent a single cell or a range of cells, are a significant tool in your mastery of Excel. As you learned in Chapter 3, moving from one location to another in a worksheet is made easier by range names, and finding a specific cell in a large or complex worksheet virtually requires them. But what else can they do for you? Assigning descriptive names to cells and ranges will save you a great deal of time when building formulas and functions, making it easier for you to remember what cell or range a formula refers to. As you build a worksheet, you should name significant ranges—important cells that contain information you'll want to find quickly or that you know you'll be using in formulas and functions.

If your Excel data is set up in a list or database format, for example, you could assign the name Database to the entire list, including the field names. This enables you to use the specified range name in Database functions that refer to the database. In addition, the Database range name is automatically updated to accommodate records that you add while using the data form.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint