WPS Sequence in WPS Spreadsheet helps you generate continuous numbers, letters, dates, and other patterned entries in batches; it includes 5 core tasks, with 1 available without membership and 4 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 5 | Matches the number of rows in the How-to Index |
| Available without membership | 1 | Matches the number of Free rows in the index |
| Membership-related items | 4 | Matches the number of membership-required rows in the index |
About This Feature
Overview
Sequence is a fill feature in WPS Spreadsheet for Windows. It helps you generate continuous data in a selected range based on rules. You can create arithmetic, geometric, or date series, and you can also use membership-related quick-entry options for 123, ABC, and Roman numeral sequences.
Core tasks include:
- Sequence: Set the start value, step value, end value, and fill direction.
- Enter 123 Sequence: Generate continuous numbers starting from 1 in the selected range.
- Smart Toolbox Enter 123 Sequence: Complete the same type of number fill from the membership toolbox.
- Smart Toolbox Enter ABC Sequence: Generate continuous letters starting from A.
- Smart Toolbox Enter Roman Numeral Sequence: Generate continuous Roman numerals starting from I.
This feature is useful for list numbering, date planning, worksheet setup, training examples, and template initialization. It reduces repeated manual input and helps keep sequence-based entries consistent.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device in a currently supported system environment |
| App version | The latest version of WPS Office is recommended |
| Network | Basic sequence filling can be used locally; keep a network connection available for membership verification when needed |
| Other | You need to open WPS Spreadsheet normally and have edit access to the target worksheet |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Download the Windows installer, complete the setup wizard, and launch WPS Office |
| Post-install check | Open WPS Spreadsheet and confirm that the Fill menu is available on the Home tab |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Spreadsheet can generate arithmetic, geometric, and date series from Home > Fill > Sequence, and it also provides membership-related quick-entry options for 123, ABC, and Roman numeral sequences. | Microsoft Word provides the SEQ field to number chapters, tables, figures, and other items in a document. | Google Sheets provides spreadsheet editing, formulas, collaboration features, and enhanced Smart Fill for data work. | Notion databases support properties such as Number, Formula, Status, and ID for structured records and tracking. | Adobe Acrobat provides Bates Numbering to add sequential identifiers to PDF pages, with prefix and suffix options. |
| WPS Advantages | Advantage: WPS keeps sequence filling inside the spreadsheet interface, with both standard sequence settings and several quick-entry options for worksheet ranges. | Compared with WPS: Microsoft's documented feature here focuses on document object numbering rather than filling spreadsheet cell ranges from a ribbon menu. | Compared with WPS: Google Sheets emphasizes online spreadsheet collaboration and Smart Fill, but the cited page does not describe the same local menu-based sequence dialog used in WPS. | Compared with WPS: Notion is oriented toward database properties and workspace organization rather than spreadsheet range filling from a fill menu. | Compared with WPS: Adobe focuses on PDF page identification and document-set numbering rather than worksheet cell sequence filling. |
| Official Source | — | SEQ field | Google Sheets training and help | Database properties | Bates Numbering in PDF files |
Overall Conclusion
WPS Sequence is more directly aligned with worksheet fill scenarios where you need to generate patterned values across selected cells. The compared products also support numbering or structured data workflows, but their documented features focus more on document fields, online collaboration databases, or PDF page indexing than spreadsheet range filling.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How Sequence helps |
|---|---|---|---|---|
| 1 | Sales list numbering | Sales and operations teams | Manual numbering takes time | Use Sequence to generate continuous item numbers |
| 2 | Date planning | Admin and project staff | Filling date columns one by one is slow | Use Sequence to create date series |
| 3 | Training examples | Teachers and trainers | Sample data needs to be prepared quickly | Use Enter 123 Sequence or Enter ABC Sequence |
| 4 | Index organization | Finance and archive staff | Numbering formats need to stay consistent | Use number or Roman numeral sequence fills |
| 5 | Template setup | Frequent spreadsheet users | New templates often need repeated starter content | Use different sequence entries to fill ranges at once |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Standard Sequence fill | ✅ Available | ✅ Available |
| Enter 123 Sequence | ❌ Membership required | ✅ Available |
| Smart Toolbox Enter 123 Sequence | ❌ Membership required | ✅ Available |
| Smart Toolbox Enter ABC Sequence | ❌ Membership required | ✅ Available |
| Smart Toolbox Enter Roman Numeral Sequence | ❌ Membership required | ✅ Available |
| Other advanced features | Depends on the current account benefits page | More advanced features can be unlocked based on the subscription plan |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| You only need arithmetic, geometric, or date series from time to time | Free | It covers basic spreadsheet sequence filling |
| You often work with batch numbering, letter sequences, or Roman numeral sequences | WPS Premium | It gives direct access to multiple quick-entry options and reduces repeated steps |
| Your team also needs broader advanced office features | WPS Premium | It can be combined with additional account benefits for more advanced workflows |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page