+ Reply to Thread
Results 1 to 3 of 3

Delete Named List

Hybrid View

AndreaC Delete Named List 07-07-2010, 09:45 AM
sweep Re: Delete Named List 07-07-2010, 09:55 AM
AndreaC Re: Delete Named List 07-07-2010, 11:07 AM
  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Delete Named List

    Hi All,
    I have a problem that should be simple to solve but I cannot find a solution by searching through the forum...
    I have created some named lists in my worksheet, now I want to remove them but I cannot find any option to delete the name or manage lists etc.
    The reason this is so important is because I need to reuse the name of the list for another list!
    I am using Excel 2007.
    Thanks,
    Andrea

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,454

    Re: Delete Named List

    Hi,

    Use CTRL & F3 to open the names manager,

    Or Formulas > Defined Names > Name Manager
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    07-07-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Delete Named List

    Thank you so much. they do like to hide things in strange places

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1