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

Chapter 2. Using Range Names > Using Worksheet Text to Define Names

Using Worksheet Text to Define Names

When you use the Define Name dialog box, Excel sometimes suggests a name for the selected range. For example, Figure 2.3 shows that Excel has suggested the name Rent for the range C7:F7. As you can see, Rent is the row heading of the selected range, so Excel has used an adjacent text entry to make an educated guess about what you'll want to use as a name. (Note, too, that the Refers To formula specifies the worksheet name, so Excel also assumes that you want to create a sheet-level name.)

Figure 2.3. Excel uses adjacent text to guess the range name you want to use.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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