How to Use the COLUMNS Function in WPS on Windows

Use the COLUMNS function through 4 how-to topics, all available in WPS Spreadsheets on Windows with the formula bar and worksheet cells.

How-to Index

How-to Guide

1. Enter the COLUMNS function

Entry point: Formulas tab → formula bar

1. Open WPS Spreadsheets and select the cell where you want to show the result.
2. Type = in the formula bar or directly in the cell.
3. Type COLUMNS( to start the formula.
4. Enter the referenced range and close the parenthesis.
5. Press Enter to return the result in the cell.

Success Criteria

• On-screen result: The target cell shows the returned column count.
• Next action: You can continue editing the formula or copy it to other cells.

Tips While Using

• Common mistake: If you do not start with =, the content may be treated as plain text.
• Environment note: The formula must be entered in an editable worksheet cell.

2. View syntax prompts and complete the argument

Entry point: Formulas tab → formula bar

1. Select the target cell and type =COLUMNS(.
2. Watch for the automatic syntax prompt.
3. Enter the correct reference argument based on the prompt.
4. Check the parentheses and range, then press Enter.

Success Criteria

• On-screen result: A syntax prompt appears while you enter the function.
• Next action: After the argument is complete, the formula returns a result.

Tips While Using

• Common mistake: Unmatched parentheses or an incomplete range can cause an error.

3. Use COLUMNS in a cross-sheet reference

Entry point: Formulas tab → formula bar

1. Select the cell where you want the result.
2. Type =COLUMNS(.
3. Switch to another worksheet and select the target range.
4. Return to the current sheet and confirm that the reference is complete.
5. Press Enter to finish the calculation.

Success Criteria

• On-screen result: The formula includes a cross-sheet reference.
• Next action: You can change the referenced range and review the updated result.

Tips While Using

• Common mistake: An incomplete sheet name or range reference can affect the result.

4. Check automatic recalculation

Entry point: A cell that already contains the COLUMNS formula

1. Enter the COLUMNS formula and confirm the initial result.
2. Adjust the referenced range or related data layout.
3. Check whether the result cell updates accordingly.
4. If needed, select the formula cell again to review the referenced range.

Success Criteria

• On-screen result: The returned value updates when the referenced range changes.
• Next action: You can continue analysis based on the refreshed result.

Tips While Using

• Common mistake: If you change cells outside the actual referenced range, the result will not change.