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

Excel in Practice

Named ranges make it easy for you to find information that may not be visible, without scrolling down or across (or both) within your worksheet's rows and columns. Click the drop-down arrow in the Name box (left of the Formula bar) to see a list of named ranges in a workbook, and then click a name to see the dimensions of a particular range highlighted in the worksheet. You can use existing range names to quickly create formulas and also enable others viewing your worksheet to more easily identify the source data used in a formula.

Range names also make it easier for other people to navigate your worksheets. For example, you can immediately jump to a named range in the worksheet by pressing F5 to display the Go To dialog box and then double-clicking the named range. While you can go overboard in naming ranges, it's better to risk that than to spend too much time referring to cells and ranges by their cell addresses. Figure 12.13 shows a worksheet that contains several named ranges created for use in formulas, to explain cell content, and for the purpose of quick formatting of similar sections of data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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