How to automatically increase the drop-down numbers in excel: First, mark 1 and 2 in the first two cells where there is an increasing sequence; then select these two cells and place the mouse in the lower right corner of the second cell; Then when the mouse changes to [ ], hold down the left button of the mouse and drag downwards; when you finally drag to the required number, release the mouse.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to automatically increase excel drop-down numbers:
Step 1: First, type 1 and 2 in the first two cells where there is an increasing sequence
Step 2: Then select these two cells and place the mouse on the lower right corner of the second cell
Step 3: When When the mouse changes to [ ], hold down the left mouse button and drag downwards. You can see that each time you drag to a cell, a number prompt
will appear. Step 4: Then When you drag to the number you need, release the left mouse button, and an increasing sequence is completed, as is the horizontal sequence.
Related learning recommendations:excel tutorial
The above is the detailed content of How to make drop-down numbers automatically increase in excel. For more information, please follow other related articles on the PHP Chinese website!