How to quickly enter 10,000 serial numbers in Excel_How to quickly enter 10,000 serial numbers in Excel

How to quickly enter 10,000 serial numbers in an Excel table? Many big guys who deal with form work often encounter this problem. In this article, PHP editor Xigua will share a very practical method on this issue, which can help everyone save a lot of time and energy and ensure the accuracy of data input.

First enter [Sequence] and number [1] in the open form:

Click the [Start] option on the toolbar and select [ Rows and Columns], select [Fill] from the secondary menu, and then click [Sequence]:

In the pop-up dialog box, select [Column] to generate the sequence, and type It is [Arithmetic sequence], the step value is [1], and the end value is [10000]:

After clicking OK, you will find that column A has been filled with the sequence:

Move the mouse to the last cell and you will find that the serial number has reached 10000:

The above is the detailed content of How to quickly enter 10,000 serial numbers in Excel_How to quickly enter 10,000 serial numbers in Excel. For more information, please follow other related articles on the PHP Chinese website!