How to Use the WRAPROWS Function in WPS on Windows

Use WRAPROWS through 3 how-to topics in WPS Spreadsheet on Windows, and choose the method that matches your workflow.

How-to Index

How-to Guide

1. Enter WRAPROWS through the Insert Function dialog

Entry point: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for WRAPROWS in the dialog box.
4. Select the function and click OK.
5. Fill in the required arguments in the function arguments window.
6. Click OK to insert the formula.

Success Criteria

• The current cell contains a WRAPROWS formula.
• The full function structure is visible in the formula bar.
• The result area returns reorganized values based on the specified number of items per row.

Tips While Using

• Use the English function name WRAPROWS when searching.
• Keep the argument order consistent with the function arguments window.
• If the result needs to spill into multiple cells, make sure the target area is not blocked by existing content.

2. Type a WRAPROWS formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =WRAPROWS(...) directly in the cell or in the formula bar.
3. Complete the required arguments.
4. Press Enter to confirm.
5. If needed, watch the formula prompt while typing to review the structure.

Success Criteria

• The formula calculates normally after entry.
• The result expands into adjacent cells by row.
• You can select the cell again and continue editing the original formula.

Tips While Using

• Separate arguments with English commas.
• If an error value appears, check the referenced range and argument types.
• Existing content in the spill range may affect the displayed result.

3. Review WRAPROWS syntax and argument details

Entry point: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Type WRAPROWS in the search box.
3. Select the function to review its syntax and argument descriptions.
4. If a help link is available, open it to read more details.
5. Return to the worksheet and adjust the formula based on the guidance.

Success Criteria

• You can see the WRAPROWS function name, syntax structure, and argument descriptions.
• You can identify which values should be entered for each argument.
• The adjusted formula result is closer to the expected output.

Tips While Using

• Confirm that the source array range matches the intended number of values per row.
• If the result is unexpected, first check whether the referenced range is correct.
• Online help pages require an internet connection.