+ Reply to Thread
Results 1 to 5 of 5

Brain Freeze - Cell that has selection items

  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2021
    Posts
    42

    Brain Freeze - Cell that has selection items

    I'm having a brain freeze. I want to build a cell that has a selection arrow button that when you click the little down arrow, a number of selections come up (such as "oz.", "lb." etc..)

    Can someone help me with the term for this so I can search how to build one? Maybe even give me instructions to build one?

    Thank you so much!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: Brain Freeze - Cell that has selection items

    If I understand correctly that is a Drop down cell.

    Here is one source.

    https://support.office.com/en-us/art...9-C5402DCE407B

    I just queried "drop down list in excel" and several hits popped up.
    Dave

  3. #3
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2021
    Posts
    42

    Re: Brain Freeze - Cell that has selection items

    That's it! Thank you for the quick reply!!

  4. #4
    Registered User
    Join Date
    09-17-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Brain Freeze - Cell that has selection items

    hello there,

    did you mean "Data Validation"?

    go to Data Tab - Data Validation - Data Validation
    in Setting Tab, chose Allow Tab and select List

    in Source Tab, you can key in any value you want. example : 10,20,30 (must follow by comma symbol ",")

    or in Source Tab, you can chose from a Data Range.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: Brain Freeze - Cell that has selection items

    You are welcome. Thank you for the feedback and marking your thread Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. cell contains integer and text and a stumped brain
    By trianglehead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2017, 06:12 PM
  2. Silly Excel Formula Question (having a brain freeze moment)
    By rjw524 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 02:46 PM
  3. Value wise top 10 Items as per Selection parameters
    By mannu.bhatia11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2014, 06:32 AM
  4. [SOLVED] Value wise top 10 Items as per Selection parameters
    By mannu.bhatia11 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-06-2014, 08:04 AM
  5. Brain Freeze or old age
    By bscs in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-15-2014, 11:17 PM
  6. [SOLVED] SUMIF brain freeze !!
    By andycuk7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2013, 06:01 AM
  7. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1