Results 1 to 2 of 2

Thread: HELP about Drop down list and data validation in excel

  1. #1

    Question HELP about Drop down list and data validation in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    1.How do I create a drop down list and data validation rule using these cities??? AND
    2. How do I create a validation routine that only accepts a time between 8:00 am and 5:00 pm???
    Canada's 10 largest cities
    Toronto
    Montreal
    Vancouver
    Ottawa
    Edmonton
    Calgary
    Quebec
    Winnipeg
    Hamilton
    London

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,490
    Articles
    0
    Excel Version
    Excel 2016
    Here is how to create a data validation list: http://www.contextures.com/xlDataVal01.html

    and here is how to create the time limitation: http://www.contextures.com/xlDataVal06.html


Posting Permissions

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