Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: how to create a cell pull-down menu

  1. #1
    Join Date
    10th March 2003
    Posts
    167
    I was wondering how to create a pull-down menu with certain choices for a cell.

    Is this possible in Excel? If so, how?

    Please Help!
    Thanks!!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    10th March 2003
    Posts
    27
    Assuming you want the users to only choose from the selected list.

    Try using Data Validation.

    Go to an area on your sheet and enter the list of valid choices

    Then on the cell where you want the drop down list. Go into DATA - VALIDATION

    In the ALLOW drop down box choose LIST

    In the SOURCE area enter the cell ranges that have the list of valid choices.

    This does not require any VBA code.

    Trust this helps

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    6th February 2003
    Location
    London, England
    Posts
    614
    Everything is possible in Excel

    Sounds like you need the need for data validation

    Put your choices in a vertical list somewhere (say A1:A10)

    highlight them, goto "insert" then "name" then "define" and name your list (say "mylist") and ok out

    now, goto the cell(s) you want your dropdown to appear and highlight it/them

    goto "data" then "validation"
    in the settings tab, change "any value" to "list" and then change the scource to "=mylist" and okay out

    done

    :D



    ============
    marker add data validation from list
    Hope this helps,
    Chris

  4. #4
    Join Date
    24th January 2003
    Location
    Perth, Australia
    Posts
    650
    If you have a list in existence and it is on another sheet you will need to name it and refer to the range name instead of cell references.

    HTH

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    6th February 2003
    Location
    London, England
    Posts
    614
    far too slow there Neale

    Hope this helps,
    Chris

  6. #6
    Join Date
    10th March 2003
    Posts
    167
    thanks guys!

    I appreciate it!!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Create Worksheets & Pull Data From Web
    By gupta.rajeevg in forum EXCEL HELP
    Replies: 2
    Last Post: June 6th, 2007, 14:46
  2. Create Pull Down Menu
    By SHC in forum EXCEL HELP
    Replies: 1
    Last Post: March 23rd, 2007, 04:48
  3. Replies: 3
    Last Post: July 17th, 2006, 14:19
  4. Pull down menu
    By blackdog in forum EXCEL HELP
    Replies: 3
    Last Post: October 1st, 2004, 05:03
  5. Creating a Pull Down Menu
    By tompercy in forum EXCEL HELP
    Replies: 1
    Last Post: April 19th, 2003, 06:59

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
  •  
porno