Home>Article>Topics> How to make drop-down numbers automatically increase in excel

How to make drop-down numbers automatically increase in excel

coldplay.xixi
coldplay.xixi Original
2020-12-16 14:44:12 59569browse

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.

How to make drop-down numbers automatically increase in excel

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

How to make drop-down numbers automatically increase in excel

Step 2: Then select these two cells and place the mouse on the lower right corner of the second cell

How to make drop-down numbers automatically increase in excel

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

How to make drop-down numbers automatically increase in excel

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.

How to make drop-down numbers automatically increase in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn