How to make drop-down numbers automatically increase in excel

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!