How to Use WPS Sequence on Windows

Use WPS Sequence through 5 how-to topics, including the standard Sequence dialog and several membership-related quick-entry methods; start with the How-to Index and open the topic that matches your task.

How-to Index

How-to Guide

1. Use Sequence to generate arithmetic, geometric, or date series

Feature path: Home tab → Fill → Sequence

1. Select the cell that contains data or the target range you want to fill.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Sequence.
5. Set the series type, step value, end value, and fill direction as needed.

Success Criteria

• Interface result: You can see the sequence settings and complete the fill.
• What you can do next: The generated cells can still be edited, copied, or saved.

Tips While Using

• Common mistake: If you do not select the target range first, the fill result may not match the intended area.
• Environment note: For date series, confirm that the cell format makes the result easy to review.

2. Enter 123 Sequence

Feature path: Home tab → Fill → Enter 123 Sequence

1. Select the cell or range that contains data.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Enter 123 Sequence.
5. Generate a continuous number sequence starting from 1 in the selected range.

Success Criteria

• Interface result: Continuous numbers appear in the selected area.
• What you can do next: You can continue formatting, copying, or saving the worksheet.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If the selected range is incorrect, the generated area will follow the current selection.

3. Use Smart Toolbox to enter a 123 sequence

Feature path: Member Exclusive tab → Smart Toolbox → Smart Toolbox tab → Fill → Enter 123 Sequence

1. Select the cell or range that contains data.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox to open the related toolbar.
4. Open the Fill drop-down menu, then click Enter 123 Sequence.
5. Generate a continuous number sequence starting from 1 in the selected range.

Success Criteria

• Interface result: The Smart Toolbox fill result is written into the current selection.
• What you can do next: You can continue formatting the result or use it in later calculations.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If you do not open the Smart Toolbox tab first, the entry may be hard to find.

4. Use Smart Toolbox to enter an ABC sequence

Feature path: Member Exclusive tab → Smart Toolbox → Smart Toolbox tab → Fill → Enter ABC Sequence

1. Select the cell or range that contains data.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox to open the related toolbar.
4. Open the Fill drop-down menu, then click Enter ABC Sequence.
5. Generate a continuous letter sequence starting from A in the selected range.

Success Criteria

• Interface result: Continuous letters appear in the selected area.
• What you can do next: You can continue adjusting fonts, borders, or combine the result with other worksheet data.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If the target range already contains important content, confirm the overwrite area before filling.

5. Use Smart Toolbox to enter a Roman numeral sequence

Feature path: Member Exclusive tab → Smart Toolbox → Smart Toolbox tab → Fill → Enter Roman Numeral Sequence

1. Select the cell or range that contains data.
2. Click the Member Exclusive tab.
3. Select Smart Toolbox to open the related toolbar.
4. Open the Fill drop-down menu, then click Enter Roman Numeral Sequence.
5. Generate a continuous Roman numeral sequence starting from I in the selected range.

Success Criteria

• Interface result: Continuous Roman numerals appear in the selected area.
• What you can do next: You can use the result for outlines, hierarchical numbering, or sample worksheets.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If you plan to mix Roman numerals with standard numbers, confirm the target column display format first.