How to Use the WRAPROWS Function in WPS on Windows

Last updated:July 20, 2026

Use WRAPROWS through 4 how-to topics, including entering the function, filling in arguments, combining references, and checking recalculation; choose a topic from the index and follow the steps to complete it.

How-to Index

No.TopicMembership Requirement
11. Enter the WRAPROWS functionFree
22. Fill in arguments and generate the resultFree
33. Use WRAPROWS with references or nested formulasFree
44. Check the result and recalculateFree

How-to Guide

1. Enter the WRAPROWS function

Entry point: Formula bar or target cell

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type an equals sign = in the formula bar or directly in the cell.
  3. Continue by typing WRAPROWS(.
  4. Review the syntax prompt and confirm the function name and argument order.

Success Criteria

  • Interface result: The cell enters formula editing mode and shows the WRAPROWS syntax prompt.
  • Next action available: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content is treated as plain text.
  • Environment note: This must be done in an editable spreadsheet cell.

2. Fill in arguments and generate the result

Entry point: Formula bar

  1. After WRAPROWS(, enter the source cell range or array to be processed.
  2. Type a comma and enter the number of values to display in each row.
  3. Add a padding argument if needed, or close the formula directly.
  4. Press Enter and check whether the result spills into rows as expected.

Success Criteria

  • Interface result: The result appears in the current cell and its spill range.
  • Next action available: You can revise the arguments and adjust the number of values per row.

Tips While Using

  • Common mistake: Missing closing parentheses or separators can cause a formula error.
  • Environment note: The spill area needs enough empty cells for the result.

3. Use WRAPROWS with references or nested formulas

Entry point: Formula bar

  1. In the first WRAPROWS argument, enter a range from the current sheet, a reference from another sheet, or the result of another formula.
  2. Add the remaining arguments as needed and keep the formula structure complete.
  3. Check whether the referenced range is correct.
  4. Press Enter to confirm the result.

Success Criteria

  • Interface result: The result is generated as a new two-dimensional layout based on the referenced content.
  • Next action available: You can continue editing the reference range or combine it with other formulas.

Tips While Using

  • Common mistake: Referencing the wrong range can produce an unexpected layout.
  • Environment note: When using cross-sheet references, make sure the referenced data exists.

4. Check the result and recalculate

Entry point: Result cells and source data range

  1. Modify the source data referenced by WRAPROWS.
  2. Observe whether the result area changes accordingly.
  3. If the result does not update as expected, check whether the formula is complete.
  4. Recalculate if needed, then confirm the updated result again.

Success Criteria

  • Interface result: The result area stays aligned with changes in the source data.
  • Next action available: You can continue editing the source data or adjust the formula.

Tips While Using

  • Common mistake: Entering numbers as text can affect later calculations or checks.
  • Environment note: In complex worksheets, watch for circular references or invalid references.