The solution to the problem that the excel serial number drop-down is all 1: 1. Enter 1 in the form and press the Enter key to confirm; 2. Drag the small plus sign in the lower right corner of the form downward; 3. Click to pop up button; 4. Click "Popup Sequence" in the list.
The operating environment of this article: Windows 10 system, Microsoft Office Excel 2016 version, DELL G3 computer
How to solve the problem that the excel serial number drop-down is all 1 ?
Step one: First, we enter 1 in the form and press Enter to confirm.
Step 2: Next, we drag the small plus sign in the lower right corner of the table downwards.
Step 3: Then, we click the button as shown in the picture, and we will find the list that pops up.
Step 4: Next, we click “Popup Sequence” in the list.
Finally, we will find that they are arranged in the sequence of numbers 1-N.
Recommended study: "Excel Tutorial"
The above is the detailed content of How to solve the problem that the excel serial number drop-down is all 1. For more information, please follow other related articles on the PHP Chinese website!