The WPS table sets the procedure for automatically adding serial numbers

Source: Internet
Author: User
Tags sort

When making a table using the WPS form, you often need to add an ordinal number. Two common ways to do this are to either hold down the SHIF key or add them manually. However, both of these additions have a common disadvantage, that is, when you need to enter too many rows, it is troublesome to add serial numbers manually. Today's small series will introduce you to the third method, by setting, you can automatically add directly. Let's take a look at it!

WPS table

Set the contents of ordinal 1:

The sequence number is set to auto sort, implemented using the method of inserting the function. Enter "=row ()-2" in the table and carriage return confirmation. The contents of the table are displayed in the formula bar.

About-2 here, notice that the difference between the ordinal and the custom ordinal of the table is observed. The difference is a few minus a few.

Manually select the number of added ordinal lines:

Click the cell in ordinal 1, hold down the SHIFT key, and we want to add 12 lines and click the cell with the ordinal 14. Select Finish.

Click Rows and Columns on the Start menu bar and select Fill down in the Fill option.

Custom ordinal add complete.

The method of manually adding an ordinal applies to a table with fewer rows, but it has the ability to automatically sort ordinal numbers. After you delete a row, the following number is automatically decremented.

To automatically add an ordinal number of rows:

Click on the ordinal 1 cell. Select "Sequence" in the Fill option.

In the Sequence window, select columns. We need to arrange the ordinal by column. In the "End value", fill in the number 20. Are you sure.

The serial number is automatically queued to 20.

A method that automatically adds an ordinal number to a table with more rows. This method adds an ordinal number that does not have the ability to automatically sort.

The above is the WPS table how to automatically fill in the serial number method introduction, hope to be helpful to everyone!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.