How to pull out numbers from 1 to 100 in Excel

Enter 1 in the first cell A1, and enter 2 in the lower cell A2.

Select these two cells, move the mouse to the lower right corner of the selection box, and wait until the mouse turns into a black cross.

Left click with the mouse and [pull down] until the number in the white box changes to 100 and let go.

This is the most basic method, followed by the advanced and most accurate operation method. If you encounter a large sequence filling from 1 to 1000, please be sure to use this method. .

Click [Fill]-[Series] in the [Start] option bar above.

Select row or column filling, select arithmetic sequence, fill in 100 as the end value, click OK, and the table will automatically fill in 1 to 100. It can also be filled automatically after clicking OK.

The above is the detailed content of How to pull out numbers from 1 to 100 in Excel. For more information, please follow other related articles on the PHP Chinese website!