How to solve the problem that the excel serial number drop-down is all 1

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!