How to operate the number arrangement in Excel (for example, automatically from 1 to 100)

1. Open the excel table, drag the cells, and find that the numbers do not increase the displayed values in ascending order.

2. After dragging a cell, you can click the symbol in the lower right corner of the selected area.

3. After clicking, a drop-down box will pop up, and select "Fill in order" in the options.

4. Cell values that were not sorted in ascending order before can be automatically changed to incremental data.

5. Or hold down the "Ctrl" key while dragging the mouse to achieve the same effect.