How to Use WPS Sequence on macOS

Use WPS Sequence on macOS through 5 how-to topics, including Sequence, Enter 123 Sequence, Enter ABC Sequence, and Roman numeral sequence tools; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Use Sequence to generate rule-based data

Feature entry: Home tab → Data Processing → Fill → Sequence

1. Select the source cell or the target cell range.
2. Click Data Processing on the Home tab.
3. Open the Fill menu and select Sequence.
4. Choose the sequence type you need, such as arithmetic, geometric, or date.
5. Set the step value, stop value, and fill direction, then confirm.

Success Criteria

• Interface result: The selected range is filled with ordered content based on your settings.
• What you can do next: You can continue editing, formatting, copying, or saving the result.

Tips While Using

• Common mistake: If the target range is not selected first, the fill result may not match your expectation.
• Environment note: If the stop value is left empty, the fill usually continues to the end of the selected range.

2. Use Enter 123 Sequence to fill continuous numbers

Feature entry: Home tab → Data Processing → Fill → Enter 123 Sequence

1. Select the cell range where you want to fill numbering.
2. Click Data Processing on the Home tab.
3. Open the Fill menu.
4. Click Enter 123 Sequence.
5. Fill the selected range with continuous numbers starting from 1.

Success Criteria

• Interface result: The selected area shows continuous numbers such as 1, 2, and 3.
• What you can do next: You can continue formatting the cells or use the values in later calculations.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If the selected range already contains data you want to keep, the new sequence may replace it.

3. Use Smart Toolbox Enter 123 Sequence

Feature entry: Membership tab → Smart Toolbox → Smart Toolbox tab → Fill → Enter 123 Sequence

1. Select the target cell range.
2. Click the membership-related tab.
3. Open Smart Toolbox.
4. Open Fill and click Enter 123 Sequence.
5. Generate a continuous number sequence in the selected range.

Success Criteria

• Interface result: The selected range displays continuous numbering.
• What you can do next: You can continue using other filling tools in Smart Toolbox.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If you are not signed in to a membership-enabled account, the entry may be unavailable.

4. Use Smart Toolbox Enter ABC Sequence

Feature entry: Membership tab → Smart Toolbox → Smart Toolbox tab → Fill → Enter ABC Sequence

1. Select the target cell range.
2. Open the membership-related tab and then open Smart Toolbox.
3. Open Fill and select Enter ABC Sequence.
4. Confirm the action.
5. Fill the selected range with continuous letters such as A, B, and C.

Success Criteria

• Interface result: The selected area shows continuous letter labels.
• What you can do next: You can use the result for grouping, labeling, or teaching materials.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If the selected range is too short, the result is limited by the range size.

5. Use Smart Toolbox Enter Roman Numeral Sequence

Feature entry: Membership tab → Smart Toolbox → Smart Toolbox tab → Fill → Enter Roman Numeral Sequence

1. Select the target cell range.
2. Open the membership-related tab and enter Smart Toolbox.
3. Open the Fill menu.
4. Click Enter Roman Numeral Sequence.
5. Fill the selected range with Roman numerals such as I, II, and III.

Success Criteria

• Interface result: The selected area shows continuous Roman numeral labels.
• What you can do next: You can use the result for chapter, clause, or list numbering.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If the cells already contain content, confirm whether you want to overwrite it before running the command.