Such as click modify, and then will jump out, on the right side of the five choices, let him to choose, this model, how to implement, click modify and five choices, in the same box, I figure it is in order to describe clearly, column two boxes, was successively in the order of present relationship between them, not necessarily word, excel can realize can also,

CodePudding user response:

Excel can do it by data availability, such as "sequence" or an integer from 1 to 5,

CodePudding user response:

reference 1/f, zara's reply:

excel can do it by data availability, such as "sequence" or an integer from 1 to 5,

, please click on the modify how to jump out to sequence the cohesion between the implementation?

CodePudding user response:

Excel data validity using "sequence" when creating the sequence in the range, click data cell will form a down list, select data; The performance is not the same with you, but its basic function is relatively close to the requirement,

CodePudding user response:

Implement as you said, but is different from what I expected, you this is through the keyboard input number, I had better be to list all of the options, let others choose one of the Numbers, but thank you very much,

CodePudding user response:

Sequential patterns is a choice, choose from the excel to create the list referred to in sequence,