View original (French)

Data validation always displays the first choice

Solved
PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   -  
PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   -
Hello,

I have a drop-down list (Cell A1) created with data validation.
A;B;C;D;E;F;G;

When I make my first selection (example: G), G appears in A1 (normal!)

If I reopen the drop-down list, Excel automatically suggests the previous choice
(G)

I would like my drop-down list to reset and suggest the first choice (A).

How can I do this please!

Best regards,

EXCEL2010

4 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    I don't quite understand the problem
    As long as the value of A1 is not changed (by the choice in the dropdown list), the last validated value remains displayed
    When you click on A1, the proposed list is always the same, right?

    Can you send a sample file (use cjoint.com)

    Best regards
    0
    1. PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   21
       
      Hello,

      Yes, the proposed list is still the same, but I have to scroll up with the elevator to select, for example, A

      With a list of 200 lines, scrolling up takes more time...
      0