How can you make drop down boxes in excel
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How can you make drop down boxes in excel

  1. #1
    Guest

    Default

     
    I need to have drop down boxes where I can choose a particular item such as: taxable, non-taxable, tax-deferred. Is there a way to do this without creating a pivot table?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See Help file for Data Validation - List option

  3. #3
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If you want to dropdown list a set of items and be able to add your own item, then:

    To the right of your sheet build a list one item per row in one column. Click the column ID to highlight the column, then use:

    Insert-Name-Define then name your list.

    Click the cell you want the list in, then:

    Data-Validation-Settings (select "List" from Allow) in "Source" add =your list name, Like: =myList

    Then copy the cell you just put the dropdown list in and highlight the other cells you want the list in and hit special paste-validation.

    Now when a cell with your dropdown is selected, it grows a dropdown arrow, which when clicked returns your selection list.

    To limit the selection to only the values in your list:

    Data-validation-Settings
    Allow: List
    Check: Ignore blank
    Check: In-Cell dropdown
    Source: =$AA:$AA (this is the column "myList" is in.

    Then:

    Tab to Error Alert
    Check: Show
    Style: Stop
    Title: Error!
    Error Message: Only select from the dropdown list!

    Now the user can put a wrong entery in the cell but they cannot move from the cell without an Error Box Message and the options to fix or erase their entery or start over.

    Hope this helps. JSW

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com