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

Chapter 2. Using Range Names > Using the Define Name Dialog Box

Using the Define Name Dialog Box

Using the Name box to define a range name is fast and intuitive. However, it suffers from two minor but annoying drawbacks:

  • If you try to define a name that already exists, Excel collapses the current selection and then selects the range corresponding to the existing name. This means you have to reselect your range and try again with a new name.

  • If you select the range incorrectly and then name it, Excel doesn't give you any direct way to either fix the range or delete it and start again.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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