+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : how to manage your lists

  1. #1
    Registered User
    Join Date
    09-04-2010
    Location
    North Wales
    MS-Off Ver
    Excel 2007
    Posts
    31

    how to manage your lists

    hello everyone.

    I made a quote system a few months back (first time in excel) i left it for 2 months and now i have forgot everything!

    What i made were a few drop down lists on different tabs and 1 tab was my quote page.

    I made a few lists so when i go to Data validation and click lists and price F3 i have a few ready made lists from tabs. What i wanted 2 know is how do i edit them lists? or remove them as i want to make the lists somewhere else on another tab.

    If i go to the box that says the coloum and row and click on the arrow you see all my lists. how do i edit them? or delete them

    hope you understand me.

    Thanks
    Dave

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: how to manage your lists

    I believe you are talking about named ranges,
    Should be located in the Formulas Ribbon,
    Define Names is there

+ 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