View original (French)

Dropdown in a cell: it's not working, no small arrow

stephvet -  
JCB40 Posted messages 3058 Registration date   Status Member Last intervention   -
Hello,
I'm frustrated: I found out through forums and Excel help how to create drop-down lists. I properly create my list of options on a separate sheet (in table form or simple list, neither of which works). I correctly select the range of cells to which I want to apply the drop-down menu, then I go to "data" "data validation," then "list," and I make sure to check "in-cell dropdown," I take note of the message that appears when the cell is selected.
Then I select the data range (=Sheet2!$A$1:$A$7 ... I finally select with the mouse) then I confirm the selection and then confirm the general settings.
The cells indeed only accept A, B, C, or D and no other entry, but I don't have an arrow allowing me to display the drop-down menu.
Unfortunately, no useful research on the internet ///// HELP SOS HELP
A thousand thanks in advance

Configuration: Windows / Firefox 70.0

7 answers

  1. eugene
     
    In return, the dropdown list seems to be working normally.

    https://cjoint.com/c/ILsn4uFR11m
    1
  2. eugene
     
    The same with a drop-down list in column S and changes to the titles CLOTURE and CLOTURE 2.
    1
  3. eugene
     
    Hello,
    If the list of options is on another sheet, you need to name it, for example options, clients, etc.
    Then you will use this name in the form =options, for example; instead of specifying the corresponding range in the form a1:a7.
    Best regards
    0
    1. Stephvet
       
      Thank you Eugène
      Unfortunately, even like that, there's no arrow on the cells, but it's impossible to write anything other than what's included in the list.
      0
      1. eugene > Stephvet
         
        Carefully erase the non-functioning dropdown lists using "Edit/delete all" and start again as indicated in my post; it should work.
        In principle, you cannot enter a mention in a dropdown list that is not present; that's the purpose of this function to avoid entry errors. Unless there is some option somewhere that I am not aware of...
        See example:
        https://cjoint.com/c/ILsl7zmwFRm
        0
  4. via55 Posted messages 14391 Registration date   Status Member Last intervention   2 759
     
    Hello

    Weird!
    Post an example of your file on mon-partage.fr, copy the created link, and come back to paste it here so we can see it

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    0
    1. stephvet
       
      https://d.docs.live.net/82424356d7d76c18/Trading%20Journal.xlsx

      In the gray-filled cells of column R, they should display an arrow when selected or even all the time if possible. On sheet 2, the table should include the elements from the dropdown menu (or column AF of sheet 1 and AG for column S).
      Thank you again for your responsiveness.
      0
  6. Stephvet
     
    Okay, thank you, I'll do it very quickly.
    0
    1. eugene
       
      Thank you for sending the file in question via CJoint or Mon-Partage, I can't open your link.
      0
      1. stephvet > eugene
         
        https://cjoint.com/c/ILsnyrOxVoh
        I hope this works


        In the gray fill of column R, the cells should display an arrow when selected, or even all the time if possible, and on sheet 2, the table that includes the elements from the dropdown menu (or column AF sheet 1 and AG for column S
        Thank you again for your responsiveness.
        0
  7. stephvet
     
    First of all, I would like to thank you for your help. I didn't do it right away because I was very busy with my work. Then I forgot.
    Once again, a big thank you for giving your time to help me. I still haven't found the solution, but it's not a big deal. I ordered Excel for DUMMIES.

    I take this opportunity to wish you a very happy New Year 2020 and a long and happy life so you can continue to help others as you do.

    Stéphane
    0
  8. JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Hello,
    An example of your file with explanations would be appreciated.
    To send a file,
    Make sure there are NO CONFIDENTIAL DATA
    you need to use an attachment site like cjoint.com

    Go to this site: https://www.cjoint.com/
    Click on browse,
    Find your file,
    click on open,
    Click on "Create the cjoint link",
    Copy the link,
    Come back here and paste it in a reply...
    Best regards

    --
    Start by doing what is necessary, then do what is possible, and you will suddenly be doing the impossible without realizing it. Saint Francis of Assisi
    0