How to automatically generate WPS serial number
In daily office work, WPS Office is one of the preferred tools for many users. Whether you are writing reports, making forms, or editing documents, the automatic serial number generation function can greatly improve work efficiency. This article will introduce in detail the automatic generation method of serial numbers in WPS, and provide you with practical tips based on hot topics on the entire network in the past 10 days.
1. Steps to automatically generate WPS serial number
The automatic generation function of serial numbers in WPS is mainly used in text documents and tables. The following are the specific operation steps:
1.Automatically generate serial numbers in text documents
- Open WPS text and select the content that needs to be added with a serial number.
- Click the "Start" tab in the top menu bar.
- Find the "Numbering" button in the "Paragraph" ribbon and click the drop-down arrow to select the preset serial numbering style.
- If you need to customize the style, select "Custom Number" for more settings.
2.Automatically generate serial numbers in tables
- Select the cells in the table that need to be filled with serial numbers.
- Enter a starting number (such as "1") in the cell, then hold down the Ctrl key and drag the fill handle downward to fill.
- Or use the formula "=ROW()-1" to automatically generate consecutive serial numbers.
2. Combining hot topics across the Internet with WPS techniques
According to the hotspot data of the entire network in the past 10 days, the following are hot topics related to office efficiency:
| Ranking | hot topics | Search volume (10,000) | Associated WPS Tips |
|---|---|---|---|
| 1 | AI office tools | 350 | WPS smart assistant automatically generates content |
| 2 | Document collaboration | 290 | Serial number synchronization during multi-person editing |
| 3 | Table shortcut keys | 240 | Alt+Enter quickly wraps the line to fill in the serial number |
| 4 | Graduation thesis formatting | 180 | Automatic numbering of multi-level lists |
3. Advanced techniques for WPS serial numbers
1.Automatic numbering of multi-level lists
Suitable for papers or long documents: Set the hierarchical relationship of chapter titles through the "multi-level numbering" function, and WPS will automatically maintain numbering continuity.
2.Custom serial number format
In the "Custom Number" window you can set:
- Numbering style (numbers, letters, Roman numerals, etc.)
- suffixes (e.g. "Chapter X")
- Fonts and indents
3.Table serial number automatically updated
When deleting/inserting rows, use the following method to keep serial numbers consecutive:
- Use the "=SUBTOTAL(3,$B$2:B2)" formula in the WPS table
- Use the "Number" function in WPS text forms instead of manual input
4. Solutions to common problems
| Problem phenomenon | Cause analysis | Solution |
|---|---|---|
| Serial numbers are not consecutive | Manually modified number | Right click on the number → "Restart at 1" |
| Multi-level numbering confusion | Paragraph indentation setting error | Adjust levels with "Increase indent" |
| Form filling fails | Autofill is not enabled | File→Options→Edit→check "Drag-and-drop text editing" |
5. Suggestions for improving efficiency
1.Shortcut key combinations
- Quick numbering: Alt+H+N
- Increase indent: Tab
- Reduce indent: Shift+Tab
2.style save
The set numbering style can be saved through "New Style" to facilitate direct call next time.
3.Cloud sync
Save frequently used templates to WPS cloud documents, and the format will be automatically kept consistent when used across devices.
By mastering these skills, you can quickly complete various automatic serial number generation requirements in WPS. Combined with the current popular AI office trend, you can also try the latest smart numbering function launched by WPS to achieve more efficient document processing. It is recommended to pay attention to the WPS update log regularly to obtain more automated functions.
check the details
check the details
en
