Home  >  Article  >  Software Tutorial  >  How to set up WPS table to automatically generate serial number WPS automatic generation serial number operation method

How to set up WPS table to automatically generate serial number WPS automatic generation serial number operation method

WBOY
WBOYOriginal
2024-08-28 11:04:41748browse

How to set up WPS form to automatically generate serial numbers? Many users need to use serial numbers to sort when editing tables, but they all do it manually, which is very troublesome. In fact, in the table, you can set up the automatic generation of serial numbers. Many people don't know how to do it. It doesn't matter. Next, the editor will share with you the specific operation methods, hoping to bring help to the majority of users. How to set up the WPS table to automatically generate serial numbers 1. First open the wps table. If you want to add the sorted serial number 1234, enter 1 in the first cell of the serial number column.

WPS表格怎么设置自动生成序号 WPS自动生成序号操作方法

2. Select cell No. 1, then place the mouse a little bit in the lower right corner and drag downwards.

WPS表格怎么设置自动生成序号 WPS自动生成序号操作方法

3. At this time, the incremental 1234 serial number can be automatically generated.

WPS表格怎么设置自动生成序号 WPS自动生成序号操作方法

Users can also double-click when the mouse turns into a cross, or they can automatically sort in ascending order of 1234. However, this method can only be used when there is content in another column. After double-clicking, the sorting will automatically stop at the place where there is no content, which is particularly easy to use.

WPS表格怎么设置自动生成序号 WPS自动生成序号操作方法

The above is the detailed content of How to set up WPS table to automatically generate serial number WPS automatic generation serial number operation method. 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