Results 1 to 11 of 11
  1. #1
    Speechless
    Points: 361,613, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 37.0%
    Achievements:
    SocialYour first GroupRecommendation Second ClassVeteran50000 Experience Points
    Tre4ISU's Avatar
    Join Date
    Dec 2008
    Location
    Estherville
    Posts
    19,213
    Points
    361,613
    Level
    100
    Thumbs Up
    Received: 536
    Given: 72

    HELP: Excel Experts

    I am creating a universal order form for work. I would like to make it so there is a drop down list of choices because sometimes things get mixed up and I want others to be able to easily choose the correct option. How to I make it so a cell is a drop down list? Any help is much appreciated. Thanks.


    I'm on Twitter too: Tre4ISU

    Or so I have read.

  2. #2
    Bench Warmer
    Points: 8,518, Level: 27
    Level completed: 62%, Points required for next Level: 232
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    jl112481's Avatar
    Join Date
    Jul 2007
    Location
    Franklin, WI
    Posts
    290
    Points
    8,518
    Level
    27
    Thumbs Up
    Received: 6
    Given: 0

    Re: HELP: Excel Experts

    It's quite easy.

    1. Click on Excel Help
    2. Search "Drop Down List"
    3. Select "Create a drop-down list from a range of cells"
    4. Follow directions



  3. #3
    Starter
    Points: 30,634, Level: 53
    Level completed: 81%, Points required for next Level: 216
    Overall activity: 1.0%
    Achievements:
    Recommendation Second ClassVeteran25000 Experience Points
    tzjung's Avatar
    Join Date
    Mar 2007
    Location
    Des Moines, IA
    Posts
    985
    Points
    30,634
    Level
    53
    Thumbs Up
    Received: 62
    Given: 119

    Re: HELP: Excel Experts

    Quote Originally Posted by yaman3 View Post
    I am creating a universal order form for work. I would like to make it so there is a drop down list of choices because sometimes things get mixed up and I want others to be able to easily choose the correct option. How to I make it so a cell is a drop down list? Any help is much appreciated. Thanks.
    You have to use 'Cell Validation'. You can either construct a list, or reference a cell range. If you use your excel help and search for 'Validation' it should walk you through the process. Hope this helps!



  4. #4
    Legend
    Points: 209,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 25.0%
    Achievements:
    Veteran50000 Experience Points
    jbhtexas's Avatar
    Join Date
    Oct 2006
    Location
    Arlington, TX
    Posts
    10,919
    Points
    209,363
    Level
    100
    Thumbs Up
    Received: 254
    Given: 145

    Re: HELP: Excel Experts

    Quote Originally Posted by yaman3 View Post
    I am creating a universal order form for work. I would like to make it so there is a drop down list of choices because sometimes things get mixed up and I want others to be able to easily choose the correct option. How to I make it so a cell is a drop down list? Any help is much appreciated. Thanks.

    Put your list into cells somewhere in the worksheet.

    Data Menu-->Validation
    Select "List" from the "Allow: dropdown on the "Settings" tab.
    Select the cells that contain your list in the "Source:" field.

    If your list is in the same workbook, but on a different worksheet, I think you have to used a named range in the "Source:" field.


    "Don't worry Boss...they can't do nothin' 'til they're through sparklin'..."

    Avatar - America's new superhero...Cenex Guy

  5. #5
    Speechless
    Points: 361,613, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 37.0%
    Achievements:
    SocialYour first GroupRecommendation Second ClassVeteran50000 Experience Points
    Tre4ISU's Avatar
    Join Date
    Dec 2008
    Location
    Estherville
    Posts
    19,213
    Points
    361,613
    Level
    100
    Thumbs Up
    Received: 536
    Given: 72

    Re: HELP: Excel Experts

    Sweet, thanks guys.


    I'm on Twitter too: Tre4ISU

    Or so I have read.

  6. #6
    Speechless
    Points: 361,613, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 37.0%
    Achievements:
    SocialYour first GroupRecommendation Second ClassVeteran50000 Experience Points
    Tre4ISU's Avatar
    Join Date
    Dec 2008
    Location
    Estherville
    Posts
    19,213
    Points
    361,613
    Level
    100
    Thumbs Up
    Received: 536
    Given: 72

    Re: HELP: Excel Experts

    OK, now, is there a way to get rid of my list and keep them in the drop down box so my worksheet is a little cleaner?

    Also, there will be three drop downs. The second and third ones will have options that are different depending on which you select with the first. How do I do that?


    Last edited by Tre4ISU; 08-25-2010 at 03:45 PM.
    I'm on Twitter too: Tre4ISU

    Or so I have read.

  7. #7
    Recruit
    Points: 6,996, Level: 24
    Level completed: 90%, Points required for next Level: 54
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    mymanfreddie's Avatar
    Join Date
    Apr 2008
    Location
    Des Moines
    Posts
    115
    Points
    6,996
    Level
    24
    Thumbs Up
    Received: 0
    Given: 0

    Re: HELP: Excel Experts

    Quote Originally Posted by yaman3 View Post
    OK, now, is there a way to get rid of my list and keep them in the drop down box so my worksheet is a little cleaner?
    You can always put the list on another sheet and then hide the sheet


    Pete & Amy
    Two great ISU fans, congratulations on the wedding!
    Paul Rhoads


    "To give anything less than your best is to sacrifice the gift."
    --Steve Prefontaine

  8. #8
    Prospect
    Points: 4,352, Level: 19
    Level completed: 26%, Points required for next Level: 298
    Overall activity: 0%
    Achievements:
    Veteran1000 Experience Points
    rob4cy's Avatar
    Join Date
    Jan 2009
    Location
    nevada, ia
    Posts
    45
    Points
    4,352
    Level
    19
    Thumbs Up
    Received: 0
    Given: 0

    Re: HELP: Excel Experts

    Quote Originally Posted by yaman3 View Post
    OK, now, is there a way to get rid of my list and keep them in the drop down box so my worksheet is a little cleaner?
    Just "hide" them. Highlight the rows or columns, right click, hide.


    I root forISU () and anyone playing the huskers ()

  9. #9
    Hall-Of-Famer
    Points: 67,757, Level: 80
    Level completed: 82%, Points required for next Level: 293
    Overall activity: 0%
    Achievements:
    SocialVeteran50000 Experience Points
    d4nim4l's Avatar
    Join Date
    Apr 2008
    Location
    West Des Moines, IA
    Posts
    4,791
    Points
    67,757
    Level
    80
    Thumbs Up
    Received: 13
    Given: 5

    Re: HELP: Excel Experts

    Quote Originally Posted by mymanfreddie View Post
    You can always put the list on another sheet and then hide the sheet
    Or put them in the same sheet in Row 6000 and hide the necessary rows. Just make sure your print area is set for the form though.



    Wide Right & Natty Lite - Loyal Sons, Forever True. With beer!

  10. #10
    Speechless
    Points: 442,293, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 9.0%
    Achievements:
    SocialRecommendation Second ClassVeteranCreated Album pictures50000 Experience Points

    Join Date
    Nov 2007
    Location
    Ames
    Posts
    23,928
    Points
    442,293
    Level
    100
    Thumbs Up
    Received: 191
    Given: 25

    Re: HELP: Excel Experts

    Quote Originally Posted by mymanfreddie View Post
    You can always put the list on another sheet and then hide the sheet
    Or put them in a column off to the side of the current sheet and hide the column.



  11. #11
    Legend
    Points: 209,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 25.0%
    Achievements:
    Veteran50000 Experience Points
    jbhtexas's Avatar
    Join Date
    Oct 2006
    Location
    Arlington, TX
    Posts
    10,919
    Points
    209,363
    Level
    100
    Thumbs Up
    Received: 254
    Given: 145

    Re: HELP: Excel Experts

    Quote Originally Posted by yaman3 View Post
    Also, there will be three drop downs. The second and third ones will have options that are different depending on which you select with the first. How do I do that?
    One way is with VBA. You can program the "Change" event for the worksheet. If the Target argument passed to the event subroutine (the cell that changed) is your cell of interest, you can write the appropriate values to the other ranges based on the value of the Target cell.

    There might be some way to do it with IF statements in the cells. I use VBA for most everything these days...


    "Don't worry Boss...they can't do nothin' 'til they're through sparklin'..."

    Avatar - America's new superhero...Cenex Guy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: TBD
  • Iowa State vs. Oklahoma
  • November 1, 2014
  • 07:00 PM