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

Chapter 3. Selecting and Naming Cells an... > Naming Ranges for Fast Access

Naming Ranges for Fast Access

After you enter some or all of a worksheet's content, you may find it easier to refer to cells and blocks of selected cells by name rather than cell address. Just as it's easier to find an employee by asking the receptionist for him or her by name than to comb the building on foot, looking in each cube or office, so finding cells and ranges by name is faster and easier than trying to find and remember cell addresses. Excel gives you the capacity to name individual cells or cell ranges so that you can find data by a logical name, and refer to the cells ranges in formulas, as described in Chapter 12, "Working with Named Ranges."

Author's Note

It's a good idea to go through large or complex worksheets and name all the key cells or ranges to which you think you'll go often. Don't wait until you wish you had created a name for an often-accessed cell!



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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