How to Use the WRAPCOLS Function in WPS on Windows

This how-to guide covers 3 topics for using WRAPCOLS, including entering the function, completing the calculation with parameters, and combining it with references and nested formulas.

How-to Index

How-to Guide

1. Enter the WRAPCOLS function and view syntax guidance

Entry point: WPS Spreadsheet worksheet → select the target cell → formula bar

1. Open WPS Spreadsheet and go to the worksheet you want to edit.
2. Select the starting cell where you want the result to appear.
3. Type = in the formula bar or directly in the cell.
4. Continue by typing WRAPCOLS(.
5. Check the syntax guidance shown on the screen to confirm the parameter order and input method.

Success Criteria

• On-screen result: Syntax guidance for WRAPCOLS appears after you type the function name.
• Next action available: You can continue entering parameters and complete the formula.

Tips While Using

• Common mistake: If you do not start with =, the content is treated as plain text.
• Environment note: You need to work in an editable spreadsheet cell.

2. Complete a WRAPCOLS calculation with the required parameters

Entry point: target cell → formula bar

1. Select the upper-left cell of the output area.
2. Type =WRAPCOLS( and then enter the source range or array you want to reorganize.
3. Continue by entering the count that controls how many elements go into each column.
4. Add other parameters if needed.
5. Press Enter to confirm the formula.
6. Check whether the result expands by columns into adjacent cells.

Success Criteria

• On-screen result: The result is returned to the worksheet area by columns.
• Next action available: You can edit the parameters and recalculate the result.

Tips While Using

• Common mistake: Missing parentheses, separators, or required parameters can cause a formula error.
• Environment note: Leave enough blank cells in the result area for the returned array.

3. Use WRAPCOLS with cross-sheet references and nested calculations

Entry point: target worksheet → formula bar

1. In the target worksheet, select the cell where you want the result to appear.
2. Enter the WRAPCOLS formula and replace the data argument with a referenced range from another worksheet.
3. Combine WRAPCOLS with other functions as needed to build a nested calculation.
4. Press Enter to confirm the formula.
5. Check whether the returned result matches the expected layout, then adjust the reference range or parameters if needed.

Success Criteria

• On-screen result: The result from a cross-sheet reference expands by columns in the current sheet.
• Next action available: You can copy the formula, adjust references, or continue analysis.

Tips While Using

• Common mistake: If the reference direction does not match your layout goal, the result arrangement may not match expectations.
• Environment note: The related worksheets and referenced ranges need to remain accessible.