Use the SEQUENCE function in WPS with 4 how-to topics; all 4 are available without membership and 0 are membership-related, so you can jump from the index to the task you need.

How-to Index

No.	Topic	Membership Requirement
1	1. Enter a basic SEQUENCE formula	Free
2	2. Set rows and columns to generate an array	Free
3	3. Set a start value and step value	Free
4	4. Combine SEQUENCE with other formulas	Free

How-to Guide

1. Enter a basic SEQUENCE formula

Entry point: Formulas tab → formula bar

Open WPS Spreadsheet and select the target cell.
Type =SEQUENCE(.
Enter a basic argument such as 2.
Type the closing parenthesis and press Enter.

Success Criteria

On-screen result: The target cell and adjacent cells show sequential numbers.
What you can do next: You can continue editing the formula or reference the returned values.

Tips While Using

Common mistake: Missing parentheses or separators can cause a formula error.

2. Set rows and columns to generate an array

Entry point: Formulas tab → formula bar

Select a blank cell.
Type =SEQUENCE(2,3).
Press Enter to confirm.
Check whether the result expands into 2 rows and 3 columns.

Success Criteria

On-screen result: The worksheet returns a 2-by-3 array of sequential numbers.
What you can do next: You can sum, reference, or format the returned range.

Tips While Using

Common mistake: If the output range is blocked by existing data, the array may not expand fully.

3. Set a start value and step value

Entry point: Formulas tab → formula bar

Select the target cell.
Type =SEQUENCE(2,3,10,-1).
Press Enter to run the formula.
Check whether the result starts at 10 and decreases by -1.

Success Criteria

On-screen result: The returned array starts from the specified value and changes by the specified step.
What you can do next: You can switch to positive, negative, or other step values as needed.

Tips While Using

Common mistake: If the argument order is incorrect, the result may not match your expectation.

4. Combine SEQUENCE with other formulas

Entry point: Formulas tab → formula bar

Select the target cell.
Enter a combined formula that uses SEQUENCE with date, text, or random-related formulas.
Press Enter to view the result.
Adjust the arguments further if needed.

Success Criteria

On-screen result: The formula returns a combined dynamic result.
What you can do next: You can copy, reference, or nest more formulas.

Tips While Using

Common mistake: For longer nested formulas, review parentheses and argument levels in the formula bar.