Results 1 to 3 of 3
  1. #1
    Lounger jpl's Avatar
    Join Date
    Jun 2002
    Location
    England
    Posts
    45
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Deletion of Range Names (XP)

    It is easy to select a few cells and then use the Name Box to give them a range name, e.g. rng1. But once the name "rng1" exists, how can the name itself (not the cells it refers to) be deleted? I'm sure I've done it before, but cannot remember how and can find no mention in the help files.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Deletion of Range Names (XP)

    Select Insert | Name | Define... to see a list of names; you can add and delete names here.

    Or download and install Jan Karel <!profile=Pieterse>Pieterse<!/profile>'s free Name Manager add-in, it has many more features than the built-in dialog.

  3. #3
    Lounger jpl's Avatar
    Join Date
    Jun 2002
    Location
    England
    Posts
    45
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Deletion of Range Names (XP)

    Thanks, Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •