SEQUENCE in WPS Spreadsheet: Build a Predictable Number Grid

The official WPS SEQUENCE lesson documents the behavior used here. It identifies WPS Office for Windows Personal. Reviewed October 19, 2026, this Chinese-language evidence does not establish an exact introduction build, every current edition, or English-global, Mac, Linux, web or mobile behavior. No new WPS execution or native screenshot was possible; the examples are independent controls or explicitly conditional fixtures.

Historical entry method versus newer releases

The 2021 lesson demonstrates selecting the complete result range, entering the formula and pressing Ctrl+Shift+Enter. Braces shown around an array formula are added by that workflow; do not type them as part of the formula. That historical method is the reproducible workflow described here.

The official Windows release log separately announces dynamic arrays in October 2023. Consequently, the older lesson’s no-dynamic-array statements are historical, not a claim that current WPS cannot expand array results. For a newer installation, confirm its array-entry behavior and available output space in that build. This guide does not import Excel spill rules, error codes, spill-reference operators or cross-workbook behavior into WPS. Monthly release notes do not establish an exact introduction build for SEQUENCE.

=SEQUENCE(rows,columns,start,step)

The WPS lesson names these four parameters in this order. This bounded signature supplies all four, without promising defaults or omitted-argument behavior.

• rows: number of result rows, here a positive whole number.
• columns: number of result columns, also a positive whole number.
• start: first value in the grid.
• step: amount added to obtain each next value.

The source’s illustrated 3-by-3 result confirms row-major filling. This is more specific than merely knowing there are nine values: 6 follows 1 horizontally, not vertically.

No source table is needed. For the historical workflow, select A2:C4, type =SEQUENCE(3,3,1,5) and press Ctrl+Shift+Enter. The official demonstration shows this arrangement, also checked independently here:

There are 3 × 3 = 9 entries. The last is 1 + (9 - 1) × 5 = 41. The first entry in the second row is 1 + 3 × 5 = 16. These two checks catch both a wrong increment and a row/column interpretation error.

The official animation is vendor evidence, not a screenshot from a run performed for this guide.

For a grid of two rows and four positions per row, select E2:H3 under the historical workflow and use:

=SEQUENCE(2,4,101,1)

Expected row 1 is 101, 102, 103, 104; expected row 2 is 105, 106, 107, 108. These are eight sequential labels for a temporary packing or classroom layout. They are generated numbers, so do not use the formula alone as a permanent transaction-ID assignment system: changing its inputs changes the generated values.

For a simple vertical list, =SEQUENCE(5,1,10,10) has five rows and one column. Independently expected values are 10, 20, 30, 40, 50. For the 2021 method, select exactly five output cells vertically before confirming.

• A transposed-looking result often means rows and columns were exchanged. 2,4 means two rows, four columns.
• In the historical method, the selected result rectangle should match the requested dimensions.
• Use positive integer dimensions for these tests. The cited lesson does not establish error behavior for zero, negative or fractional dimensions.
• The examples use positive whole-number steps. Negative steps, omitted arguments and maximum array dimensions need separate product evidence before becoming compatibility promises.
• Keep the result area separate from existing data and check the installed version’s array-entry behavior.

For an irregular random grid rather than an arithmetic progression, see RANDARRAY. For ordering an existing set of records, see SORT. SEQUENCE creates new numbers; it does not inspect or rank existing records.

• WPS SEQUENCE lesson
• WPS Windows release log, October 2023 dynamic-array announcement

Expected outputs are derived from the explicit fixtures and documented operation. They are not results observed in an installed WPS build. Check the intended edition before relying on these formulas in a shared workbook.