SEQUENCE in WPS on Windows: Introduction

SEQUENCE in WPS is a dynamic array function for generating sequential numbers by rows, columns, start value, and step value; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

The SEQUENCE function in WPS Spreadsheet helps you generate arrays of sequential numbers for spreadsheet calculation and analysis. It is useful for numbering rows, building sample datasets, creating horizontal or vertical sequences, and combining with other formulas for dynamic results.

Core capabilities include:

Generate a basic sequence directly in cells.
Control the output shape with row and column arguments.
Set a custom start value and step value.
Combine SEQUENCE with other formulas for more flexible calculations.

Common use cases include data entry, report building, test data creation, and dynamic headers in spreadsheets.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local formula entry and calculation do not require a constant internet connection; downloading, updating, or signing in does
Other	You need access to WPS Spreadsheet and permission to edit worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Windows installer and complete setup with the installation wizard
Check after installation	Open WPS Spreadsheet and type `=SEQUENCE(` in a cell to confirm that function hints appear

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports the SEQUENCE function in spreadsheets to generate sequential number arrays with rows, columns, start value, and step value for calculation and analysis.	Excel provides `SEQUENCE(rows,[columns],[start],[step])` to generate sequential numbers in an array and supports spilled dynamic array results.	Google Sheets provides `SEQUENCE(rows, columns, start, step)` to return arrays of sequential numbers in vertical or horizontal layouts.	Notion formulas can calculate with properties, built-ins, and functions, but its official help content does not describe a spreadsheet-style SEQUENCE array function.	Acrobat supports calculated form fields, predefined calculations, and custom scripts for PDF forms rather than spreadsheet array generation.
WPS Advantages	Advantage: You can generate sequential arrays directly in WPS Spreadsheet and continue using the results in the same worksheet for references, filling, and combined formulas.	Compared with WPS: Excel documents dynamic arrays and spill behavior in more detail, while the main use case remains spreadsheet calculation.	Compared with WPS: Google Sheets supports similar syntax and works well for browser-based collaboration, while WPS fits a desktop spreadsheet workflow.	Compared with WPS: Notion formulas are centered on database properties instead of cell-based array sequence generation.	Compared with WPS: Adobe calculation features are designed for PDF form fields, not spreadsheet SEQUENCE workflows.
Official Source	—	SEQUENCE function	SEQUENCE function	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
If your work focuses on spreadsheet numbering, dynamic arrays, and formula combinations, SEQUENCE in WPS covers common day-to-day needs directly in WPS Spreadsheet. Microsoft Excel and Google Sheets offer similar function patterns, while Notion and Adobe focus on database formulas or PDF form calculations for different scenarios.

Use Cases

No.	Scenario	Suitable for	Main challenge	How SEQUENCE helps
1	Generate serial numbers in bulk	Spreadsheet editors	Manual numbering takes time	Use SEQUENCE to create continuous numbering
2	Build dynamic headers	Data analysts	Month or stage headers need to be created in batches	Combine SEQUENCE with date or text formulas
3	Create sample data	Students and trainers	Preparing example data is repetitive	Use SEQUENCE to generate structured values quickly
4	Build fixed-step sequences	Finance and operations users	Values must increase or decrease by a fixed interval	Set a custom start value and step
5	Combine formulas	Advanced users	One formula alone may not be enough	Nest SEQUENCE with other functions

Membership & Benefits

SEQUENCE itself is available in the spreadsheet workflow described here; this section summarizes 4 benefit areas, including free access for core spreadsheet use and membership-related value shown on the pricing page.

Free vs WPS Premium

Feature area	Free users	WPS Premium
SEQUENCE function entry and basic calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional premium features	Refer to the pricing page for current availability	Includes more advanced features and benefits
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday study and basic spreadsheet work	Free	It already covers SEQUENCE and standard spreadsheet editing
More cloud storage or broader advanced office features	WPS Premium	Suitable if you also need additional premium tools and benefits

WPS membership center: Subscribe now