How to autofill number increment in excel

Excel data cell drop-down is a very common operation, but it is often found that the excel drop-down number does not increase, which is exactly the opposite of what we require. This article will write out the operation in detail to quickly and easily set the drop-down cell.

How to operate Excel's auto-fill number increment

1. For example, a data, pull down from it to make an increasing sequence. Place the mouse on the lower right corner of the cell and click and hold the drop-down button when it turns into a cross.

Recommended study: excel basic tutorial

2. See that the default sequence format is the same number.

#3. Click the pattern containing the cross in the lower right corner of the sequence number, and select the second fill sequence in the menu.

#4. The data of this sequence becomes increasing.

5. Another way is to fill in two or more data initially, as shown in the figure below, and select two data at the same time for drop-down. .

#6. The result is the same as before.

Note: There is an easier way to select a piece of data and pull it down to increment it, that is, hold down the CTRL key while pulling it down, and it will become an incrementing sequence.

For more excel related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to autofill number increment in excel. For more information, please follow other related articles on the PHP Chinese website!