Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Edit data validation list (2003)

    I have a spreadsheet that has dropdown lists using data validation. I am trying to edit the list (add another name) to the end of the list but it won't let me get to the end of the list to add another name. I remember another time I had the same problem and I got the answer here. Under validation criteria under "allow" - list is selected.
    In the "source" area a list is typed in separated by comma. How do I add another name to this list?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Edit data validation list (2003)

    If you click on the button to the right of the "Source:" box you should go to new dialog where you are at the end of the list...

    When done, click on the button to the right again and you will be in the datavalidation dialog again

    Steve

Posting Permissions

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