1. Click to select the position of the first serial number, select "Search and Reference" in "Formulas" in the menu bar, click it, and select "ROW" in the pop-up window "function.
2. The content in the picture will appear in the input box in the form. Ignore the pop-up window, click on the input box and enter -1 after the brackets. The purpose is to make the entered serial number 1 less than the serial number value that comes with the table. The serial number of the table before serial number 1 is equal to 1 minus 1, and the serial number after the function is subtracted. For example: the table's built-in sequence number is 3, and the custom sequence number is 1. Enter -2 after the brackets.
3. Confirm after entering the content.
4. The input box will turn into numbers.
5. Select the input box where 1 is located. When the lower right corner of the input box turns into a black cross, hold down the left button and drag the mouse downward to the specified number of lines. Then release the left button, and the serial number will be automatically generated. This method is suitable for tables with large serial numbers.
PHP Chinese website has a large number of free word tutorials, everyone is welcome to learn!
The above is the detailed content of How to sort serial numbers in wps. For more information, please follow other related articles on the PHP Chinese website!